Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx
Using Microsoft 365 Excel, learn how to use Excel formulas to create formula number incrementors to show 1,1,1,2,2,2,3,3,3… or 1,2,3,1,2,3,12,3,… using the SEQUENCE, INT and MOD functions.
Method for Any Version of Excel: <a href="https://www.youtube.com/watch?v=AIQbJAPMrEg" target=”_blank” rel=”nofollow”>https://www.youtube.com/watch?v=AIQbJAPMrEg (Excel Magic Trick 692: More About Incrementing Numbers In Formulas)
Topics:
1. (00:00) Introduction
2. (00:27) Pattern 1,1,1,2,2,2,3,3,3…
3. (01:58) Pattern 1,2,3,1,2,3,1,2,3…
4. (02:23) Example of when to use Pattern 1,1,1,2,2,2,3,3,3…
5. (03:51) Example of when to use Pattern 1,2,3,1,2,3,1,2,3…
6. (04:18) Summary, Closing and Video Links