Re: Problem with ranking numbers

From: BenjieLop (BenjieLop.1g76c0_at_excelforum-nospam.com)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 17:29:37 -0600

Pati M Wrote:
> I am having trouble with ranking numbers. I am trying to rank heat times
> for
> 7 out of 24 contestants. my rankedx numbers are going from 18 through
> 24
> instead of 1 through 7. How can I correct this? The formula I am using
> is as
> follows:
> =IF(L12="TNT",0,IF(L12="DNF",0,IF(L12="DNS",0,IF(L12="SCRATCH",0,IF(L12="DISQ",0,IF(L12="DNF/FLIP",0,IF(L12=0,0,RANK(L12,L$12:L$300,1))))))))
> each row has the same formula for the correct cell.

Check this out

http://WWW.XLDYNAMIC.COM/SOURCE/XLD.RANK.HTML

for an excellent explanation/sample of RANKING. 

-- 
BenjieLop
------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11019
View this thread: http://www.excelforum.com/showthread.php?threadid=319931