RANK function in Excel and Rank by groups by Chris Menard

[@poongak]

Deeply Appreciate your perfect teaching.

[@SteveJeongKorea]

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

[@ChrisMenardTraining]

You're very welcome!

[@zoguds]

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

[@ChrisMenardTraining]

You're welcome!

[@davidfletcher9526]

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

[@ChrisMenardTraining]

Thanks for letting me know. It is a great function.

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

[@ChrisMenardTraining]

You're welcome!

[@adelhafezi5392]

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

[@ChrisMenardTraining]

Thanks, Adel.

[@kashyapdamodar7338]

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

[@ChrisMenardTraining]

Excellent! Thank you!

[@hoyatmarcwong3490]

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

[@bobritsky]

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

[@ChrisMenardTraining]

You're very welcome!

[@shirleyshema]

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

[@dmmoore3]

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

[@ChrisMenardTraining]

Glad I could help! Thanks, Diane.

[@paulfuller3308]

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

[@y-phi148]

YOU ARE A GENIUS!!!! 🤯

[@pimaniye41]

Helped me on my assignment, thank you Chris!

[@ChrisMenardTraining]

Happy to help!

[@poejavelski148]

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

[@ChrisMenardTraining]

You're so welcome!

[@Drewxx1-n4x]

AMAZING!!!!! YOU'RE A LIFE SAVER!

[@ChrisMenardTraining]

Thank you.

[@adithyakp7208]

Thanks Chris, THis was helpful

[@razvanandreivalcu9649]

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

[@nganjng]

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

[@ChrisMenardTraining]

You are welcome!

[@jist6953]

Thank you! This helped a lot.

[@ChrisMenardTraining]

You are welcome.

[@craigs.8031]

Excellent solution. Thank you!

[@ChrisMenardTraining]

You bet! Thanks, Craig.

[@croxtren]

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

[@paulkelly5309]

THANK YOU THANK YOU THANK YOU!!!!

[@ChrisMenardTraining]

Glad to help. Thanks, Paul.

[@meltsarap]

So very helpful. Thank you so much

[@ChrisMenardTraining]

You are so welcome!

[@prashantjha7121]

Thanks man! Kam ho gaya

[@katesmith7966]

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!

[@mohammadalbizri2013]

Its helpful, thankful.

[@ChrisMenardTraining]

welcome.

[@patildevendra9617]

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

[@joeawad2089]

Thank you so much.

[@ChrisMenardTraining]

You are welcome.

[@georgewashington1414]

Great work, thank you.

[@ChrisMenardTraining]

Thanks for watching!

[@roywilson9580]

Thanks for this interesting and helpful video.

[@ChrisMenardTraining]

I'm glad you liked it. Thank you, Roy.

[@kiasca3489]

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

[@ChrisMenardTraining]

Thank you.

[@Rk-bh7ru]

Group ranking formula is skipping some number in large data set when repeated number obtain.

[@jahirulsadi88]

Thank you very much, its really helpful.

[@ChrisMenardTraining]

Glad it was helpful!

[@mar25947]

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

[@ChrisMenardTraining]

Great to hear!

[@mohamedshunaif841]

Can you explain why this works?

[@williamdmabra4174]

YOU ARE RHE BEST

[@giovanniletizia7697]

Thanks for this, how do you introduce within your formula a bit to uniquely rank?

[@diptipawar558]

Thanx very helpful

[@ljuba98]

Thank you!

[@ChrisMenardTraining]

You're welcome!

[@shauryagamer6093]

Chris, how would you handle the rank if there are duplicate numbers in the scores?

[@ChrisMenardTraining]

Here is a workaround I used for a chart. kzbin.info/www/bejne/qHeadqeKaNeZhsU

[@dolittlediehard1670]

Nice, very good but what i was looking to do was to rank on two columns at the same time, so rank by column 1 first but if there are 2 (or 3) values in column 1 that are the same then we rank in column 1 by the values held in column 2.

[@Mahesh-yn6kz]

Great vedio, very well explained 🤟

[@ChrisMenardTraining]

Thanks a lot 😊

[@humanoid769]

Excellent exactly what I wanted

[@ChrisMenardTraining]

Tony, I appreciate the positive feedback. Thank you.

[@jamescasson4988]

Chris, how would you go about doing an overall rank across several different scores. For Example, a team is measured across 3 different metrics, say productivity (higher the better), sales, and a survey score where the higher it is the better. 10 members rank differently across all three metrics, how do you show a combined overall rank?

[@ChrisMenardTraining]

It sounds like you want a weighted average. You would add a helper column in Excel and do the weighted average.

[@juandiegoavilajara6301]

excelent video!! 5/5

[@ChrisMenardTraining]

Thank you.

[@paulpells1864]

How would I list the Branch names in ranked order, thanks.

[@sachkum]

How do we use the formula in column "Rank by Branch" if the values in column "Score" are in the text format with values like "088, 100, 066, 068, 087, 066, 067, 076, 060 and 062". I understand a simple option is to manually convert these text values to numbers in the column first before applying the formula in the "Rank by Branch" column. But I want to do it through formula which would convert the column array from text to number before doing the comparison. Is there a way to do that? Have an office project where I'm stuck wondering how I can achieve this.

[@rup.ric7]

Nice vdeo, do we have this GROUP WISE ranking on google sheet??

[@isramaria9456]

Tks Sir, my problem done. 🙏🙏🙏

[@ChrisMenardTraining]

Welcome 👍

[@181stormin]

How do I rank the top 3 in different colors, that whoever is in rank 1-3 the color change automatically. Please help.

[@ChrisMenardTraining]

Still do the Rank, but also use Rank with Conditional Formatting.

[@bikassingh7469]

Ive 10 diff.numbers in the rows and I want to scoring only from 1 to5 . How do I go about this

[@priyatalwar5195]

How can we get the cumulative score basis rank value?

[@jackskippon2790]

hey I was having problems ranking my data with percentages any tips

[@edwinacuna2577]

Hi great use of the countifs function! One question ! How do i sum a column descending by groups. I use the sumif function but i get a cumulative sum by groups ascending.

[@ChrisMenardTraining]

Edwin, give me an example of what you are trying to do, please.

[@edwinacuna2577]

Chris, Thank you! I have a table with Columns (Item, Date, Puchased units,Rate) Item > aaa ,bbb, ccc , aaa , ddd, ccc, aaa, ddd, bbb / Date > 2/01/2020 , 2/01/2020 , 2/01/2020 , 23/01/2020 , 23/01/2020 , 23/01/2020 , 15/02/2020 , 15/02/2020 , 15/02/2020 / Purchased Units > 5 , 3 , 6 , 4 , 5 , 4 , 4 , 6 , 6 / Rate > 50 , 24 , 35 , 48 , 15 , 32 , 51 , 14 ,23. This table keeps track of the purchases I make for a business. Sometimes I source the same item every 20 days or so. I have another table for the items sold, I need that table to update automatically with the exact rate according to the total inventory I have for the item sold. For instance I just sold a unit of item (aaa) and in inventory I have 5 . So the item I sold is the fifth I had in inventory. That unit was purchased on january 23rd 2020 because the last time I purchased the item was on 15/02/2020 just 4 units. I need to extract the right rate. I have seen videos they pull out the last date. But here If I extract the last date for (aaa) i would get the rate = 51 which is wrong since the unit I sold has a a rate = 48. I did SUM.IF(A2:$A$2;A2;$C$2:C2) and I get the cumulative sum of the units for every duplicate > 5 , 3 , 6 , 9 , 5 , 10 , 13 , 11 , 9. I need to get > 13 , 9 , 10 , 8 , 11 , 4 , 4 , 6 , 6. The reason for this is that in row(4) I will get an 8 and If I find the right formula to tell excel to find first the group (aaa) and to match the closest approximate number of cumulative sum for "aaa" = 4 , 8 , 13 . I will get the cell reference for 8 and get the 48 Which is the right answer. If you know a better solution I would appreciate it. Thank you very much for your help.

[@osamarizwan1635]

amazing

[@sathishbabudasari1019]

Thank u

[@ChrisMenardTraining]

Welcome

[@craignelson8756]

I am trying to rank 2 seperate columns using the countifs and assumed you just add another section like i did. However Excel is giving me an error, complaining about a problem with the formula. is this NOT how to rank 2 different sets of data to one group of sample space? =COUNTIFS($B$3:$B$16,B3,$F$3:$F$16,H3:H16,">"&F12,H11)

[@MKG-No-Commentary]

Chris, I have an excel video for you. It should help out a few people. It is about ranking if you have multiple scores and there is a tie on the highest score. The next highest score is then used along side the first. Let me know if you are interested and I can send it to your email.