Hi all,
I am using the following formula to rank based on a couple of conditions:
At present it ranks the lowest value in column C as the highest but I actually want to rank it as the lowest.
How can I do this?
Thanks
I am using the following formula to rank based on a couple of conditions:
Code:
=COUNTIFS($A$2:$A$477321,A2,$E$2:$E$477321,E2,$C$2:$C$477321,">"&C2)+1
At present it ranks the lowest value in column C as the highest but I actually want to rank it as the lowest.
How can I do this?
Thanks