Forum Discussion
Solved
#N/A Error with RANK.EQ
I'm working on an Excel file that contains roughly 622 numbers. I'm trying to use the RANK.EQ function to capture the rank of each number in the list. Duplicate numbers should have the same rank (e...
As variant your numbers could be formatted as text, you may check in any empty cell as =ISTEXT(D2).
you can try following formula
=RANK.EQ(D2,$D$2:$D$623,1)
It is just that you might need to use the absolute reference for D2:D623
- Thank you for the suggestion. The formula still returns the #N/A value. I’m guessing it’s an issue with the source data that I’ll need to review.
As variant your numbers could be formatted as text, you may check in any empty cell as =ISTEXT(D2).
- Thank you! That was indeed the issue. I was incorrect about the cell formatting in the source. Converting the formatting did the trick! Much appreciated!