Excel Forum
Similar Content
Keep Leading Zeros in Numbers in Excel - 2 Ways
Tutorial: I'll show you 2 ways to add and keep leading zeros in front of numbers in Excel. These t...
Require a Unique List of Numbers in a Range in Excel
Tutorial: I'll show you how to require a user to enter a unique number into a range of cells in Exce...
Get the Decimal Part of a Number in Excel
Tutorial: How to get the decimal part of a number without any rounding in Excel. This tip allows you...

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.