I have a RANK Formula like this: =RANK(J12,J$9:J$728)
I am doing a Sort so if I have a Duplicate item in Column A of that same row of the Rank I do not want it to execute the RANK
So Like this if A12 is equal = to A11 Then "DUP"
How can I combine a test into the Rank Formula & do not execute it if previous line has a DUPE in Column A?
Thanks for your help
I am doing a Sort so if I have a Duplicate item in Column A of that same row of the Rank I do not want it to execute the RANK
So Like this if A12 is equal = to A11 Then "DUP"
How can I combine a test into the Rank Formula & do not execute it if previous line has a DUPE in Column A?
Thanks for your help