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?

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

Follow this topic