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)...
Typically you would need to incorporate the full date/time into the formula
= 1 + COUNTIFS(year, year, date,"<"&date)and not rely on position.