I have two columns a & b shown below:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><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




4 .7<o


2 1.2<o


3 50<o


1 12.4<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


1 12.4<o


2 1.2<o


3 50<o


4 .7<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


Thanks a ton!!
-Ryan