I am trying to write a formula where if the data appears in the column more than once, it is assigned a number and that number keeps increasing sequentially.
or example, in Col A, the name Ty appears 3 times. The first time it appears, column should say 1, the second time it appears, col B should be 2 and the third time it should be 3. What is the best way to write this? Countif doesn't seem to work as it gives me the total count vs. increasing 1 at a time.