Ascending order plus...

[alopez]

I have a random list of numbers in column A (but not every cell has a number), and a name of color in B. I want to list all the numbers in Column A in ascending order in Column D and the corresponding color in Column E. Some of the number repeat, but the colors never do. This has to be automatic, as sometimes I change the numbers and I don't want to have to update the formula.

<table border="0" cellpadding="0" cellspacing="0" width="320"><colgroup><col style="width:48pt" span="5" width="64"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td style="height:12.75pt;width:48pt" height="17" width="64">Col A</td> <td style="width:48pt" width="64">Col B</td> <td style="width:48pt" width="64">
</td> <td style="width:48pt" width="64">Col D</td> <td style="width:48pt" width="64">Col E</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">4</td> <td class="xl65">Black</td> <td class="xl65">
</td> <td class="xl65">1</td> <td class="xl65">Orange</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">2</td> <td class="xl65">White</td> <td class="xl65">
</td> <td class="xl65">2</td> <td class="xl65">White</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">4</td> <td class="xl65">Blue</td> <td class="xl65">
</td> <td class="xl65">4</td> <td class="xl65">Blue</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">
</td> <td class="xl65">Yellow</td> <td class="xl65">
</td> <td class="xl65">4</td> <td class="xl65">Black</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl65" style="height:12.75pt" height="17">1</td> <td class="xl65">Orange</td> <td class="xl65">
</td> <td class="xl65">
</td> <td class="xl65">
</td> </tr> </tbody></table>