How to autofill a cell with an incrementing number for each time a value appears in another column

Column formula request:

I'm trying to assign a numeric value to a cell and increment up for each instance a code shows up in another column.

For example, if a column has NH002 in it 4 times, the first time, the cell should have a value of 1, and repeat until it gets to 4. Once NH003 starts, it would start over at 1 and count up.

I figured "=IF(" would be the start, but not even sure where to go from there to get it to increment.


Best Answer

  • Paul H
    Paul H ✭✭✭✭✭✭
    Answer ✓


    If I understand correctly from you other post you are getting these submission weekly so you could use the week number based on submission date. Using min(collect to find the first entry and subtract it from the current weeknumber