Change Ascendancy of "Rankifs" Formula

[rob51852]

Hi all,

I am using the following formula to rank based on a couple of conditions:

=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

 

[Fluff]

Try changing the > to <

 

[rob51852]

*Hangs head in shame a feels silly*... thanks Fluff!

 

[Fluff]

You're welcome & thanks for the feedback