It still returns an "#N/A".
How can you make "#N/A" disappear?
The formula does not ignore empty spaces.


Paul Sheppard Wrote:
Hi cardingtr

Try this

=IF(B3="","",RANK(B3,$B$3:$B$12,1))


--
cardingtr
------------------------------------------------------------------------
cardingtr's Profile: http://www.excelforum.com/member.php...o&userid=27027
View this thread: http://www.excelforum.com/showthread...hreadid=465810