I need a formula in column BH which ranks the activity in column A given the followin criteria:
Rank by Age (column AJ) - oldest is No. 1.
Column BI = NON CIVILS
Column BB = ISBLANK
Rank 1 to 10 for the above criteria when LEFT(AP2,1)="R"
Rank 1 to 10 for the above criteria when LEFT(AP2,1)="A"
Rank 1 to 10 for the above criteria when LEFT(AP2,1)="G"
Display rank results as R1 0081 03ABCD
I have manually typed in the results.
Thanks if you can help.
Bookmarks