Resolved: The RANK-function in newer versions of Excel
The RANK-function doesn't work with newer versions of Excel. I tried RANK.EQ and it seems to fulfil the function of RANK. Is it okay to use it?
1 answers ( 0 marked as helpful)
Hello Eva,
Thanks for reaching out! Great to hear from you.
So, RANK is a function that is deprecated but still available in Excel for compatibility with older versions.
All you need to do is type =RANK(
...and continue to enter the arguments - it'll work
Alternatively, please use RANK.EQ
Best,
Ned