Last answered:

11 Jan 2021

Posted on:

08 Jan 2021


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)
Posted on:

11 Jan 2021

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 

Submit an answer