Conditional Rank Formula using COUNTIFS - Custom RANKIF Function

In this video, we will use the COUNTIFS function to create a conditional rank formula.

Although Excel has a RANK function to rank values in a list, it does not have a RANKIF function for conditional rankings.

The good news is though that there are ways to do it. In this video the ever-versatile COUNTIFS function (one of the best around) gets the job done.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[TheForgeFunctionalFitness]

This is gold!
I'm sure most people are unaware just how powerful Excel really is.
Thanks.

[Pankaj-Verma-]

One of the greatest Excel Channel on Youtube.

[amymestancik]

One of the best explanation I've heard! Thank you.

[rakeshjoshi]

Great video - please include something for duplicate ranking.

[mohideenthassim]

Thank you Alan, very useful video
Cheers
Mohideen

[venkataramana]

Pls help me to eliminate duplicate ranks

[dennislemley]

Exactly what i needed, amazing! Thank you!

[GarvitGupta-fs]

Hey, Thanks for sharing! I am stuck with one case. so, let's say from your data example London has two records with the same values 54 Euros. In that case, I want to rank them in order say the first record as ranked 3 and the next record with London and value 54 the rank should be 4. Can you help me with that formula?

[mabr]

Thanks sir, but now how if i want to add 1 criteria? Example rank per month per location from sales? Thanks

[adirondackspeedskatingclub]

Thank you this is perfect for what I needed.

[bibekanandasahoo]

This is great sir but how can we implement DENCE RANK if anyone has any solution please comment!

[mkashif]

This is not working if the numbers are repeating and we want a same rank for the repeating values.

[shivamsinghal]

Supurb!!!!

I am wondering why such logics cant I find.😄

[sarimufti]

Thank You very clear, can you please help me here, when I have the same but I have duplicate number and I don’t want it to skip numbers.

[anthonynorman]

Thank You,
this help me a lot.

The ultimate prize is to get DAX and or Power Query M to it.

I have a Vehicle Allocation file, inside there a single vehicle can do multiple trips. With a ranking on the 1st to last trip

[entertainmentgalaxy]

nice video and please share workbook with your videos

[muralikrishna-vqmq]

sir how to takle with duplicate values

[naveenofficial]

Sir how to exclude #N/A errors in rank??

[Congenialable]

this doesn't work if the value of London is same in different date. then it omits the number 2, 3, 4 and so on.

[jonnathanjon]

Hello..how can we rank an item ie "Location" based on aggregate of its value ie by "sales" . say aggregate sale for London is 1774 .So all London rows should be ranked as 1 then take the total of Chicago and rank all Chicago as 2 based on its total sales. accordingly .Finally how can get a top 5 ranking updated automatically based on this. Appreciate your help on this