I'm using this formula in Column A =IF(G3="","",IF(G3=G2,A2,ROW()-2)), which will show a tie for the same rank (i.e. Rank 1 [Bell and Brown] and Rank 4 for both Beckham and Elliott). What would be the formula to rank them 1-5? I would prefer not to show a tie.
Thank you in advance!
<tbody>...