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.