Excel Magic Trick 1114

Formula For Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 2…

DESCRIPTION

See how to create formula for Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 1, 18443 2, 18444 2, 18445 2, 18446 3….
See formula that uses the functions ROWS, INT and the join symbol Ampersand &
Formula element to create sequential numbers like 18440, 18441,18442.
Formula element to create repeating numbers like 1, 1, 1, 2, 2, 2,3, 3, 3….

WORKBOOKS