• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.



New Member
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.


  • RANK.EQ Error snapshot.png
    RANK.EQ Error snapshot.png
    33.6 KB · Views: 14
Check the cell value with ISNUMBER before passing it to rank, or just wrap your formula in IFERROR.
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.
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.