Euro5

asked on

# Rank in excel formula by groups

I need to take a Weight column and rank it to find top 10.

Complications - there are duplicate Weights and I have to rank by group.

I attached a sample to help - column H is the group, column R is the weight.

I need to know the top 10, but the rest can be blank or have zeros.

I just need to know if they are in the top 10, not even the exact rank.

Hopefully the example will help!

Desperate - I have tried multiple solutions, but none that work for this.

Thank you!!!

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Thanks Patrick! I do have 365 - I will try now!

How about Pivot Table and filter to show only Top 10

See attached; amended the column Q values to make them unique.

ASKER

Which gives me the ranks like 1, 68,72, because of the duplicates.

I could also use a formula that identifies which of those rankings are the top 10 for that group.

But I need like a large formula or something like that?

Thanks to anyone who can help me with this one!