Excel Forum



Excel Magic Trick 336: Incrementing Numbers In Formulas


Learn about the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions :to:
1)Increment from small to big
2)Increment from big to small
3)Increment a difference (Arithmetic Sequence)
4)Increment a ratio (Geometric Sequence)
5)Repeating Sequences
6)Use WEEKDAY function to repeat the numbers 1 to 7.
7)Learn about the ROWS, COLUMNS, MOD, ROUND, and WEEKDAY functions:





Got a Question? Ask it Here in the Forum.