I am in a strange situation about an EXCEL formula, have spent nearly 10 hours to find something for it, but could not achieve what I wanted to.
May be you can help.
The below photo will explain you my concern.
Rank in Column E should be based on the combination of values in Column A, Column B, Columns C and the absolute value in Column D.
E.g. Row 1 to 17, Column-D had a value of 7 (Row 7 - 13) which is the highest for the Project-1 (Column C)
Similarly Row 18 - 32, Column-D had a value of 8 (Row 20 - 27)) which is the highest for the Project-2 (Column C)
The expected outcome is shown in column E (TOP Z).