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,"")}
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]in order[/TD]
[TD]drop nr[/TD]
[TD]ID[/TD]
[TD]New drop a to z[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]3[/TD]
[TD]A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]3[/TD]
[TD]A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]2[/TD]
[TD]A[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]5[/TD]
[TD]B[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]3[/TD]
[TD]B[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]2[/TD]
[TD]B[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]1[/TD]
[TD]B[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]
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,"")}
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]in order[/TD]
[TD]drop nr[/TD]
[TD]ID[/TD]
[TD]New drop a to z[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]3[/TD]
[TD]A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]3[/TD]
[TD]A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]2[/TD]
[TD]A[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]5[/TD]
[TD]B[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]3[/TD]
[TD]B[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]2[/TD]
[TD]B[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]1[/TD]
[TD]B[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]