issue of rank

[sna]

Hi Dear

I need your help for ranking the duplicate

Also attached with expected output.

Thank

[sna]

Cancelled

[snasui]

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

[sna]

It is not like I need

[snasui]

The unique list of your data is:

100
95
94
90
80

Why the result of 80 is 4 instead 5?

[sna]

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

[snasui]

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.

[sna]

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

[snasui]

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.

[sna]

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

[snasui]

What is Group A in your attach file?

[sna]

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

[snasui]

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)

[sna]

Thank you