How to use RANK formula with multiple criteria

< Back to Search results

 Category: [Excel]  Demo Available 

How to use RANK formula with multiple criteria




The user requires the following:

Store Grade A B B B B B B B B C D D B
Store Name Store 1 Store 2 Store 3 Store 4 Store 5 Store 6 Store 7 Store 8 Store 9 Store 10 Store 11 Store 12 Store 13
Units Sold 25 100 27 90 25 37 10 10 15 25 0 100 90
Rank 7 1 6 3 8 5 11 12 10 9 13 2 4

Tried getting the above outcome on ranking, with =RANK(B3,B3:N3), not getting desired results.

The first criteria being the units sold in store and second criteria being the grading of the store.

For example, Store2 and Store 12 sold 100 units each but Store2 being Grade"B" gets Rank 1 over Store 12.





Obtained from the OzGrid Help Forum.

Solution provided by NBVC.


See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets


See also:

How to use RANK function ignoring only zero values
How to rank formula that returns an alpha rank if more than one value has the same rank


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


stars (0 Reviews)