Excel Magic Trick 707: RANK with Criteria - SUMPRODUCT

Download Excel Start File people.highline.edu/mgirvin/Y...
See how to rank values based on one criteria using the SUMPRODUCT function. Another amazing formulas from the Mr Excel Message Board.
Rank small number is best.
Rank big number is best.
Download file: people.highline.edu/mgirvin/Ex...

[@excelisfun]

I am glad that you liked the video!

[@excelisfun]

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

[@matthewscalise954]

This video, along with so many others of yours, has come in so handy to me. Thanks!!!

[@nadermounir8228]

Absolutely clever formula 👏

[@excelisfun]

I will have to do an update on this formula using the COUNTIFS. Glad you liked this, Nader : )

[@excelisfun]

@VideoVixenKitten , Check out:
Excel Magic Trick 337: RANK function 10 Examples
and
Excel 2010 Preview #1: New Rank Function RANK.AVE

[@markbologna7693]

Awesome and easy to follow. Thanks!

[@terenceada9140]

This is very helpful! Thank you!

[@devingoldberg7415]

Works great, this is awesome

[@Travelwithyeti]

Great Video, I am struggling with removing duplicates once the range is ranked, Can you please suggest ?

[@VideoVixenKitten]

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

[@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

[@prod2one]

Can you combine both formulas?

[@faithelijah1359]

Thanks for the trick. But I got duplicate values using the formula on my data. How can I get unique values?

[@excel2314]

hi guy can you tell me why we should add -- ?

[@carlmalcolm10]

Is possible add a criteria to only rank some of the names but not all?

[@muslimsahibtorun]

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