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


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