Forum Discussion
Assign sequence numbers to rows based on Year in a table and stick with the records
Hello, I am looking to assign sequence numbers to rows based on Year, and but when a new year starts, restart numbers as well. Please see the example below, I was able to use =COUNTIF($B$2:B2,B2)...
If you want the numbers to stick, you cannot use formulas.
So after using the formulas to generate the sequence numbers, select the column, copy it (Ctrl+C), then paste special (Ctrl+Alt+V) as values. This replaces the formulas with their result.