View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rsenn
 
Posts: n/a
Default To Rank on two Criteria


tckok56

Although I don't see how to get the RANK function to directly take
your two columns as the fields to be ranked, it is easy enough to create
from those two columns a third column to get a single rankable column
that ranks the way you want. A sample using your data is posted at
this link.

http://www.anywhereenterprises.com:8...AApQZOAApQZpQZ


Briefly, using your data, convert the first column from a little
number to big number sequence to a big number to little number
sequence. Your numbers range from 1 to 5, so do it as 6 minus the
original number. This will reverse the order. Call this column AA.

Then multiply column AA by a big number; 10,000 in this case.
Call this column AB.

Then add your second column of numbers, the ones from 14.9 to
84.8, to column AB. Call this result column AC.

Then use the rank function based on column AC.

Let me know if this helps.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=497232