Please can someone help!
I need the ability to rank (based on score in Column AK with the highest number being ranked 1)
This should only rank if column H has a status of "Pipeline". Any other status (or blank) should be ignored in the ranking criteria
In Column I is the Development Area ( AreaA, AreaB, AreaC, AreaD). This needs to be exclusive to the rank.
So If DevA has 3 rows of Pending with scores of 18, 17 and 16 it would rank these as 1, 2 and 3
and if Dev B has scores of 17, 15, 13, then this would also rank as 1, 2, 3 - as the Development Area in this case is different)
I need the ability to rank (based on score in Column AK with the highest number being ranked 1)
This should only rank if column H has a status of "Pipeline". Any other status (or blank) should be ignored in the ranking criteria
In Column I is the Development Area ( AreaA, AreaB, AreaC, AreaD). This needs to be exclusive to the rank.
So If DevA has 3 rows of Pending with scores of 18, 17 and 16 it would rank these as 1, 2 and 3
and if Dev B has scores of 17, 15, 13, then this would also rank as 1, 2, 3 - as the Development Area in this case is different)
