RANK function in Excel and Rank by groups by Chris Menard

The Rank function in Excel returns the rank of a number in a list. You can rank in ascending or descending order. The RANK function has been replaced by the RANK.EQ function which came out with Excel 2010. With the RANK function, you do not have to sort.
This video came from Taylor who was sorting by revenue numbers descending and then manually ranking with 1, 2, 3, etc...

Countifs Function in Excel by Chris Menard

The RANK.EQ function has three arguments. Two are required and one is optional.
RANK.EQ(number,ref,[order])
* Number is required. The number whose rank you want to find.
* Ref is required. An array of, or a reference to, a list of numbers. Non-numeric values in Ref are ignored.
* Order is optional. A number specifying how to rank number.

#msexcel #rankfunction #excel #countifs #functions

Chris Menard's Website:

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[SteveJeongKorea]

Thank you so much. The "Rank by groups" is very helpful for me. What a genius you are!

[zoguds]

Thank you very much. Especially this “rank by groups” trick - it saved alot of my time!

[calilthomas]

That's exact what I was looking for, since filter function apparently is not accepted within rank function.
Very ingenious solution. Thanks a lot!!!

[davidfletcher]

used this formula recently to help a colleauge and it saved them hours!! thanks!!

[bobritsky]

Thank you Chris! I was looking for a way to enumerate list of categories and this came in handy

[kashyapdamodar]

Thank you, Chris. This helped me a great deal to accomplish an urgent need at work today.

[adelhafezi]

Thanks a lot. I spent almost two hours in YouTube to find this trick!

[hoyatmarcwong]

Thanks a lot for creating this video! It's taught me a lot, especially "pressing F4 to make the range absolute"!

[dmmoore]

This was just the help I needed today. Thank you!

[paulfuller]

Thanks Chris, really helpful, exactly what I was looking for!

[shirleyshema]

That's a great solution for the ranking in group, thank you!

[patildevendra]

Chris kaka, Thank you(dhanyawad 🙏🙏) from india

[poejavelski]

Thank you so much! This is exactly what I needed.

[pimaniye]

Helped me on my assignment, thank you Chris!

[mar]

Thank you! This was clearly explained, and way better than the udemy course I was taking, lol. 😁

[kiasca]

just great, i HAVE DUPLICATES AND I WANT TO SORT THE, M IN ASCENDING OR DECENDING, BUT THIS PART WAS REALLY HELPFUL

[nganjng]

It's really helpful for me. Thank you very much!

[razvanandreivalcu]

Just what I was looking for. Thanks for the vid! You got a new subscriber.

[croxtren]

Great video. Can the result be displayed as "1 of 5"?

[katesmith]

This is so helpful thank you. Please can I ask how to then apply a sequential date range to the rank by branch outputs? For example, for Atlanta Rank 1, a start and end date, and then for Atlanta rank 2 to start after the end date of Atlanta rank 1? Hope that makes sense!