Omit or change to 0 the third argument (see Help on RANK function, or click
on the = sign at the left side of the formula bar):
=RANK(A3,$A3:$D3)
=RANK(A3,$A3:$D3,0)

Regards,
Stefi

€žwhodey€� ezt Ã*rta:


Thanks Stefi, you're a life saver. For future reference, if I wanted to
reverse the rankings so that the highest number is 1 instead of 4, how
would I do that?

Again, your help is very much appreciated.


--
whodey
------------------------------------------------------------------------
whodey's Profile: http://www.excelforum.com/member.php...o&userid=29596
View this thread: http://www.excelforum.com/showthread...hreadid=492977