Create a series, with SEQUENCE.
The SEQUENCE function in Excel is useful when you need a pattern. So, it might be as simple as a list of numbers, starting from one, and going up by one. Or, codes for products, that start from 1000, and go up in hundreds. Or, create a list of dates. =SEQUENCE(rows,[columns],[start],[step]) SEQUENCE has one compulsory […]