Forum Discussion

Copper Contributor

Jul 14, 2019

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

Formulas and Functions

SergeiBaklan
Jul 14, 2019
MetsMike

As variant your numbers could be formatted as text, you may check in any empty cell as =ISTEXT(D2).

Detlef_Lewin

Silver Contributor

Jul 14, 2019

MetsMike

Use absolute references for the range:

=RANK.EQ(D2,D$2:D$623,1)

MetsMike

Copper Contributor

Jul 14, 2019

Thanks for the suggestion. The formula still returns the #N/A value. I’m guessing it has to be something in the source data that needs to be addressed.