How do you rank the range of cells but ignores cells with no value?

I tried =RANK(B3,$B$3:$B$12,1) but it returns an "#N/A" if some cells
is blank in a range (B3 to B12).


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