The RANK() function cannot ignore error values

Hi, I though the RANK() function automatically ignore these missing or error values. But in fact they are not

Can you teach me how to do a ranking for a list and ignore those error values? I attached the file here.

Thanks for help.

Originally Posted by daddylonglegs

Nice answer benishiryo........although I'd make one small change. If you change the 5 to a 7 so that you have two 7s and a 6 then that formula will rank the 7s as 2 and the 6 as 3 rather than the usual 1 and 3, so to get those ranks it would be like this

=IF(ISNA(A1),"",COUNTIF($A$1:$A$5,">"&A1)+1)

Thanks a lot for the great help. This worked well.

Originally Posted by benishiryo

hi BNCOXUK, try:
=IF(ISNA(A1),"",COUNTIF($A$1:$A$5,">="&A1))

Many thanks, benishiryo