Data Sorting Problem--Should be Easy

[rdsmit1]

I have two columns a & b shown below:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
4 .7<o></o>
2 1.2<o></o>
3 50<o></o>
1 12.4<o></o>
<o></o>
<o></o>
<o></o>
I want to keep the above data intact, but in columns c & d regerate the information from columns a & b only in the following logical order:<o></o>
1 12.4<o></o>
2 1.2<o></o>
3 50<o></o>
4 .7<o></o>
<o></o>
I have experimented with Vlookup, but you have to have the first column in ascending/descending order for some stupid reason, so that won't work. I also am aware of the data>sort data option... but I want this to be automatically done without having to go thru those steps.<o></o>

Thanks a ton!!

-Ryan

 

[JoeMo]

Try this. Copy formula in C1 and D1 down.
C1 formula:

=SMALL($A$1:$A$4,ROW(A1))

Excel Workbook
	A	B	C	D
1	4	0.7	1	12.4
2	2	1.2	2	1.2
3	3	50	3	50
4	1	12.4	4	0.7
Sheet11