There are some cells containing errors #value!. I try to use rank(D2,D$2:D$125) to get the ranking .But it returns #VALUE! because of the errors . How can I ignore those cells containing errors ?

CodePudding user response：

You could use COUNTIF, which will ignore error values for the purpose of ranking.

=IF(ISNUMBER(D2),COUNTIF(D$2:D$125,">"&D2) 1,"")