Sequence number that reset if year changes
I need a formula that reset the sequence 001 if year changes
https://docs.google.com/spreadsheets/d/18GgcmPiWNh7R8Uj1xG5wdWK8w-tI8J995-6I8YnalLo/edit?usp=sharing
Solution
You could use the following in D3:
=text(iferror(if(year(C3)<>year(C2),1,left(D2,3)+1),1),"000")&"-"&right(year(C3),2)
Or if you want the result in column B change D2 to B2 in the formula.
- How to extract a list of records with certain criteria met in one table while identifiers extracted from another table?
- Using "If cell contains #N/A" as a formula condition.
- Excel Data Validation with XLOOKUP
- Error with sumproduct along subtotal to handle filtered values
- Excel: refer to column by number
- How to get sheet name using formula excel 2007
- How to use SEQUENCE formula in Excel data validation
- Is there a better method than nested if/then to evaluate if cells in one set of columns has data, and then populate a different set of columns
- Referencing Formula in another cell, not Value
- Filtering with multiple criteria output by another filter formula
- Why is SUMPRODUCT not calculating correctly?
- Groupby in excel using only formulas
- If cell contains item from range AND meets criteria in other column in range then return value
- Dynamically averaging data Per ID Per Time period
- How to reconcile the difference between two arrays with a unique tagging?
- Dynamically averaging data Per ID Per Time period Alternate Version
- Count consecutive excel cells where value is greater than 50 from left side only using excel formula
- Can you skip blank rows in a XMATCH lookup so #N/A is not returned?
- SUM with IF and AND
- transpose from one row with set a set of numbers to multiple columns with multiple rows downwards
- Using IFERROR with complex COUNTIFS
- find closed match value in matrix and return its row and column header in excel
- excel group column highlight matching values
- Excel Formula changes values after a day or so
- How to sort text values the same way as a web-based staircase generator
- VBA Code to filter a table and all its columns, whilst typing and ignoring accents
- Look up a value in a table based on two input values
- Search a column to find if string is contained in each cell of another column, return third value
- Excel to dynamically generate SQL script using formula
- Excel STOCKHISTORY for AMD