The SEQUENCE part creates a dynamic list of numbers (1, 2, 3...) that corresponds to the row index. For example, in the fifth row, the sequence returns the number 5. By dividing (/) the running total ...
If you would like to improve your Excel workflows and spreadsheets and in the process save a huge amount of time you might be interested in mastering Excel date functions. Once mastered this knowledge ...