Hello all,
I have been trying to look for the right formula, I tried different but i cannot find the solution.
Basically I am trying to rank the time in AS according to the group in A.
The formula I have now is : =COUNTIFS($A:$A,A1773,$AS:$AS,">"&AS1773)+1
With this formula, it does not give unique RANK.
Can you please help?
Thanks,
I have been trying to look for the right formula, I tried different but i cannot find the solution.
Basically I am trying to rank the time in AS according to the group in A.
The formula I have now is : =COUNTIFS($A:$A,A1773,$AS:$AS,">"&AS1773)+1
With this formula, it does not give unique RANK.
Can you please help?
Thanks,