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

Thank you very much, rsenn. Your suggestion is ver helpful.

HOWEVER, I have another problem. How can I peform the rank function if the
first criteria in the first column is in the ascending order while the other
is in the descending order (i.e. the other way round)
Thank you again
--
May the force be with you!


"rsenn" wrote:


You'll likely have to convert the two columns into one, such as by 10*
column A + 1 * column B, then rank on the new column C.

:(


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