Hi all, I have a tracker that I’m trying to create a ranking for.

So far I’ve been using:

=RANK.EQ($S3,$S$3:$S$15)+COUNTIFS($S$3:$S$15,$S3,$T$3:$T$15,”>”&$T3)

Which ranks Total AOV against Orders, if I’m correct.

What I want to do is also rank orders per hour, but I’m struggling to see how to add that in.

TOTAL AOVORDERSORDER PER HOURRANKING£33.26391111£23.3629582£22.9017683

​Hi all, I have a tracker that I’m trying to create a ranking for. So far I’ve been using:  =RANK.EQ($S3,$S$3:$S$15)+COUNTIFS($S$3:$S$15,$S3,$T$3:$T$15,”>”&$T3)  Which ranks Total AOV against Orders, if I’m correct. What I want to do is also rank orders per hour, but I’m struggling to see how to add that in. TOTAL AOVORDERSORDER PER HOURRANKING£33.26391111£23.3629582£22.9017683  Read More

​