Try instead in say, C3: =IF(B3="","",RANK(B3,$B$3:$B$12,1))
Copy down to C12
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"cardingtr" wrote in
message ...

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