Invert Numbers based on multiple criteria

Galonom

New Member
Joined
Oct 26, 2017
Messages
1
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,"")}

ABCD
in orderdrop nrIDNew drop a to z
103A1
103A1
202A2
351A3
105B1
114B2
153B3
202B4
301B5

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,778
Hi
Welcome to the board

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

Watch MrExcel Video

Forum statistics

Threads
1,102,304
Messages
5,486,065
Members
407,530
Latest member
Shameem Khan

This Week's Hot Topics

Top