How to rank names based on sales and on a group

[99829497]

Hi!
I need to rank names based on the amount sold by each person, but I have to consider the group where each person belongs. So my total value for sales must be different depending on which group I´m talking about.

I have this chart and I tried to rank with this formula:

Expected result: to get a rank from 1 to N for EACH group, so it would have 3 people with different amount of sales ranked as number 1, one in each group.

Can you help me please?

[Syndicate_Admin]

I tried again but now instead of "sales" I´m using a value that indicates a "saving" (it´s a decimal number that also could be shown as a %). I created the same ranking formula but now it didn´t work. Do you know how I can fix it?

TKS again

[ghoshabhijeet · Accepted solution]

@99829497  Here is my solution.. try this..

** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !

Good Luck 👍

[99829497]

It worked! Thank you!!

[ghoshabhijeet]

Welcome @99829497 🙏