Excel Magic Trick 707: RANK with Criteria - SUMPRODUCT

[VideoVixenKitten]

Do you mind posting your link that shows how to rank with ties?

[ExcelIsFun]

@VideoVixenKitten , Check out:

Excel Magic Trick 337: RANK function 10 Examples

and

Excel 2010 Preview #1: New Rank Function RANK.AVE

[Viewmastertje]

Thank you for the help with this great formula! I needed the same formula but then with a second criterium. Thanks to your video's I combined sumproduct and countifs and finally it worked! Maybe you can make a video for that too, imagine to add the playing day of the week and then rank Dan only playing on Saturday :-) I am looking forward to this!

[ExcelIsFun]

I am glad that you liked the video!

[RKNOAH]

Great explanation.  I just used this in a neat way to create a simple-to-update sales report ranking customers in their variable divisions, regions, and excluded those that did not qualify for my incentive program by returning a result of 0.

I've shared it here for lack of a better place to host it temporarily:

rachelnoah . com / my-work (remove spaces)

[ExcelIsFun]

I am glad that the video helped to get you a solution!

[muslimsahibtorun]

What if there is duplicates. How do you rank then such tat you get unqiue rank values.

[ExcelIsFun]

There are no dulplicates in this example: Dan 1, Rich 1, Billy 1 are all unique.

Try this video for no duplicates (there are several ways to do it):

Excel Magic Trick 337: RANK function 10 Examples