Count increase by 1 on every occurence

    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.

    You can still use COUNTIF, you simply make the range expand as you go down the column so it only includes rows up to the current one - e.g.


    =COUNTIF($A$2:$A2,A2)

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login