Here are some problems that our users have asked and received explanations on
Pivot table rank in excel 2013 is not correct
Solved by A. S. in 13 mins
I have a spread sheet with the rank function excel not working properly
Solved by S. H. in 15 mins
How to rank in excel with multiple criteria.
Solved by S. H. in 29 mins
Enter a function in cell N3 that calculates the rank of store 251 based on the averages in the range M3:M5.
Solved by S. J. in 29 mins
I need to use rank function in excel but reference numbers are in two different ranges
what I need should be like this:
=RANK(A1,A1:A8&B9:B18)
(range from A1 to A8 and the continue of range is placed on B9:B18)