Ignore #REF! error when Ranking

[jamezsez]

Hi All,

I am trying to use a Rank formula to rank a list of values, however I have a few cells that contain #REF! errors (the list of values will always contain ref errors).

When I use a =rank formula, it is returning Ref errors. If I include an =if(iserror formula, everything comes back blank.

I'm sure I am missing something basic, but I just can't put my finger on it.


Current formula (returning blanks)
=IF(ISERROR(RANK(O3,O3:$O$212)),"",(RANK(O3,O3:$O$212)))

Your assistance is greatly appreciated.

Cheers.

 

[Aladin Akyurek]

Hi All,

I am trying to use a Rank formula to rank a list of values, however I have a few cells that contain #REF! errors (the list of values will always contain ref errors).

When I use a =rank formula, it is returning Ref errors. If I include an =if(iserror formula, everything comes back blank.

I'm sure I am missing something basic, but I just can't put my finger on it.


Current formula (returning blanks)
=IF(ISERROR(RANK(O3,O3:$O$212)),"",(RANK(O3,O3:$O$212)))

Your assistance is greatly appreciated.

Cheers.

P3, copied down:

=IF(ISNUMBER(O3),1+COUNTIF($O$3:$O$212,">"&O3),"")

 

[jamezsez]

Thanks! That worked perfectly.

 

[Aladin Akyurek]

Thanks! That worked perfectly.

You are welcome. Thanks for providing feedback.