Hey just want to say thanks a mil for this simple and eloquent solution to the rank within group problem. I've ecountered this so many times in the past few years and this has got to be the best solution I've come across.
This was explained so well, thank you so much! I saw a lot of other Excel tips and tricks on this that were so much more complicated. This was awesome!
Hi, thank you for the video, this helped a lot. however, in my data, it looks like it has done the ranking correctly for the first 1000 data only. (my data has 60k rows). do you know the reason of this and how to solve it? thanks in advance.
@@DougHExcel Hi, Struggled to get this to work at first as my rank was in the reverse order from you. A number I was ranking on had data type ABC 123 in the power query editor. Changed the data type to a whole number in the power query editor and it worked. Thanks again.
it works for me. But The first column (grouping column) has to be Text typed in order to make the sorting works inside the grouped table. I don't know why
Hi, thanks for the video! I'm trying to create a rank column by multiple groups(2~3). Seems your method doesn't apply to it. Looking forward to more advanced method. Thank you!
This is awesome! However, when I try to left merge the Table7 results back onto (a duplicate of) the original data table using the equivalent of the Movie Name columns (formatted as Text), the expanded Rank column just goes 1, 2, 3 (formatted as Whole Number) in order of the original data table rows. What is going on here?? The merge preview shows the right Rank numbers. However, If I load Table7 to worksheet and then retrieve it with a new query, that merges fine.
It'll be like a reverse sort and I don't cover this BUT maybe one of the other video here will give an idea on other solutions that you can adjust to fit your use case ruclips.net/video/aHrlbNqAXT8/видео.html
Спасибо) давно искал возможность добавить индексы по группам. Жаль, что на моих больших объёмах (более 8 млн. строк) этот способ очень долго грузит(( Есть ли способ сделать это побыстрее?
hello, i want ro rank transaction dates as below based on invoices belonging to the each customer, how do i go about it. customer id invoice id transaction date RANKING A 1234 10/09/2022 1 A 67585 09/09/2022 2 B 7585 24/10/2022 1 B 75805 26/10/2022 2 C 489055 05/02/2022 - 1 D 4855 06/02/2022 1
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
Awesome thank you! Appreciate explaining this in under 20 minutes as well, about time someone kept it short and sweet :)
You're welcome!
Super .. thank you
Thank you too!
Hey just want to say thanks a mil for this simple and eloquent solution to the rank within group problem. I've ecountered this so many times in the past few years and this has got to be the best solution I've come across.
You’re welcome! Feel free to subscribe to my channel as there’s more of these type of videos get published weekly!
This was explained so well, thank you so much! I saw a lot of other Excel tips and tricks on this that were so much more complicated. This was awesome!
Glad it was helpful! Thanks for the comment!
Very well explained, thanks for this!
You're very welcome!
Hi Doug.. excellent.. works like a charm. Thanks for this tip.. very handy! Thumbs up!!
Hey Wayne...Great to hear it worked for you!
Big thanks for this. I still have difficulties to understand how it works... but it works perfectly.
Glad it worked!
Awesome video! Thank you so much for sharing
Thanks for watching!
Fantastic thank you so much. Great video!
Hi Arné Van der Schyff, thanks for the comment!
Wow! That's fantastic. Thanks a lot, Doug
My pleasure!
Thanks for this, very helpful!
Glad it was helpful!
Life saver, thanks!
So cool and nice and clear, very helpful, many thanks
Glad it helped!
So easy to follow up, thank you:)
You're so welcome!
This is Awesome ! thanks !
You’re welcome!
It helps....it more than help D....Thanks again for this awesome 👌 video ....keep sharing
My pleasure 😊
Hi, thank you for the video, this helped a lot. however, in my data, it looks like it has done the ranking correctly for the first 1000 data only. (my data has 60k rows). do you know the reason of this and how to solve it? thanks in advance.
Also used to work great but now when I've done it on a huge table the original ranking goes wrong.
Thanks Doug!
You bet!
Very thanks man!!
You bet!
Thank you so much!
You’re welcome!
Amazing, super... Thanks Alot Sir.
Thanks and welcome
Thanks so much!👍
You're welcome!😀
@@DougHExcel Hi, Struggled to get this to work at first as my rank was in the reverse order from you. A number I was ranking on had data type ABC 123 in the power query editor. Changed the data type to a whole number in the power query editor and it worked. Thanks again.
thanks! - i was stuggling with what chatgpt was telling me!
Beat the AI 🤣…Glad I could help!
This is genius!
Hi Anton Fernando, thanks for the comment!
it works for me. But The first column (grouping column) has to be Text typed in order to make the sorting works inside the grouped table. I don't know why
thanks a lot for this, i was getting frustrated.
Hi Doug, is there a way to have ties show as the same rank? I think it is called standard competitive rank?
Yes, this may give some insight ruclips.net/video/aHrlbNqAXT8/видео.html
Many thanks Bro
You're welcome!
Thanks a lot for sharing. That saved my day!
Glad it helped!
How would you account for a dense_rank?
Hi, thanks for the video! I'm trying to create a rank column by multiple groups(2~3). Seems your method doesn't apply to it. Looking forward to more advanced method. Thank you!
maybe one of these? ruclips.net/video/aHrlbNqAXT8/видео.html
Thank you sir
You're Welcome!
This is awesome! However, when I try to left merge the Table7 results back onto (a duplicate of) the original data table using the equivalent of the Movie Name columns (formatted as Text), the expanded Rank column just goes 1, 2, 3 (formatted as Whole Number) in order of the original data table rows. What is going on here?? The merge preview shows the right Rank numbers. However, If I load Table7 to worksheet and then retrieve it with a new query, that merges fine.
Thank you, but how can I rank in reverse order( ascending order)?
It'll be like a reverse sort and I don't cover this BUT maybe one of the other video here will give an idea on other solutions that you can adjust to fit your use case
ruclips.net/video/aHrlbNqAXT8/видео.html
Great example. What if two had the same volume? The rank would be 1,1,,3,4,5. How is that handled?
Other vids here may give some insights ruclips.net/video/aHrlbNqAXT8/видео.html
Спасибо) давно искал возможность добавить индексы по группам. Жаль, что на моих больших объёмах (более 8 млн. строк) этот способ очень долго грузит(( Есть ли способ сделать это побыстрее?
если исходные данные в формате CSV или TXT, это может быть быстрее
you sir desire more likes
Hi TKSRichy, thanks for the comment!
Hi Doug
How are you?
How can I connect you by email?
The about tab on my channel page will have contact info
B E S T !!!
Hi Dmytro Shtunder, thanks for the comment!
This not exactly ranking because for equal values of Volumn, this method gives different ranking.
hello, i want ro rank transaction dates as below based on invoices belonging to the each customer, how do i go about it.
customer id invoice id transaction date RANKING
A 1234 10/09/2022 1
A 67585 09/09/2022 2
B 7585 24/10/2022 1
B 75805 26/10/2022 2
C 489055 05/02/2022 - 1
D 4855 06/02/2022 1
See if any of these help Ranking Data
ruclips.net/p/PL-n8f1cY_Qw9FBA42I7DYlnwX7RgBsbT6