RANK.EQ Error

[Geosele]

I have encountered an RANK.EQ Error in last (RHS) row of attached due to the "N" cells. Could you or this community assist. Advance thanking you.

 

[Debaser]

Check the cell value with ISNUMBER before passing it to rank, or just wrap your formula in IFERROR.

 

[Geosele]

Thx @Debaser : could you explain how I do the "check cell value with ISNUMBER" and "wrap formula in IFERROR" as I'm not to familiar with these aspects am afraid.

 

[Debaser]

Instead of your =RANK.EQ(...) formula, use =IFERROR(RANK.EQ(...),"")

 

[Geosele]

Thx for update @Debaser. Yes, it gives "zero/empty cell" result. This made me realise I included a wrong column (correct one has no letter) but IFERROR use is much appreciated for future reference. Thanks again.