The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

The RANK-function in newer versions of Excel

The RANK-function in newer versions of Excel

Super Learner
0
Votes
1
Answer

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 Answer

365 Team

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 

Perfect, thank you!

5 days
JanuaryPromo
×
Complete Data Science Education
Get 50% OFF