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,"")}
<tbody>
</tbody>
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>