Invert Numbers based on multiple criteria

[Galonom]

Hi All,

basically I have managed to get "Drop nr" or let say unique rank by ID" in order" column but trying to get in reverse order "new drop a to z" instead. Colum D is showing what I want to achieve, Column B has following array formula
{=IF(C2<>"",SUM(IF(FREQUENCY(IF(C$2:C$2000=C2,IF(A$2:A$2000>A2,A$2:A$2000)),A$2:A$2000),1))+1,"")}

A	B	C	D
in order	drop nr	ID	New drop a to z
10	3	A	1
10	3	A	1
20	2	A	2
35	1	A	3
10	5	B	1
11	4	B	2
15	3	B	3
20	2	B	4
30	1	B	5

<tbody>
</tbody>

 

[pgc01]

Hi
Welcome to the board

Looking at the formula it seems you just have to change ">" to "<"