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?
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
Perfect, thank you!