Snasui Excel Forum

Hi Dear

I need your help for ranking the duplicate

Also attached with expected output.

Thank

Cancelled

The example formula in F2 is:

=MATCH(C2,AGGREGATE(14,6,$C$2:$C$11/(MATCH($C$2:$C$11,$C$2:$C$11,0)=ROW($C$2:$C$11)-ROW($C$2)+1),INDEX(ROW($C$2:$C$11)-ROW($C$2)+1,0)),0)

Enter > Copy down

It is not like I need

The unique list of your data is:

100
95
94
90
80

Why the result of 80 is 4 instead 5?

It should 4 base on group because I don't care duplicate

Please explain more detail, where is group?

I think each item in unique list is represent to a group and 80 is group 5 not 4.

it misses a number
Example - Section A should read 1,1,2,3,4
and Section B should read 1,2,2,3,4 because I don't need to skip number.is it possible?
Thanks

Can you compare your result with condition by attach file?

Point to your data and explain what condition you use for the result of that data.

My post at #3 not skip any number.

Hi dear
In Group A we have unique list:
100
95
94
80

What is Group A in your attach file?

Hi dear in column B we have group A and B .
A:5 and B:5

OK, I see. Please try with this formula:

F2

=MATCH(C2,AGGREGATE(14,6,$C$2:$C$11/($B$2:$B$11=B2)/(MATCH($B$2:$B$11&$C$2:$C$11,$B$2:$B$12&$C$2:$C$11,0)=ROW($C$2:$C$11)-ROW($C$2)+1),INDEX(ROW($C$2:$C$11)-ROW($C$2)+1,0)),0)

Thank you