Thread: Get number of a cell in a list.
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default Get number of a cell in a list.

Additional Info:

This version of the RANK function does exactly what you want:
=RANK(A1,$A$1:$A$10,1)

(I don't know why I didn't remember that in the first place!)

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=504956

Reply With QuoteReply With Quote