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