Another option other than directly error-trapping
the #N/A return of the RANK(...) itself:

In C3: =IF(ISNUMBER(B3),RANK(B3,$B$3:$B$12,1),"")
C3 copied down to C12
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--