Thread: what function in excell do i use to show lead postions in columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Cutter
 
Posts: n/a
Default what function in excell do i use to show lead postions in columns

Try the RANK() function.

=RANK(A1,A1:C1) will give the ranking of the value in A1 as compared to
all the values in range A1 to C1


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=494103

Reply With QuoteReply With Quote