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

Download “Excel Magic Trick 1101-1120” Excel-Magic-Trick-1101-1120.zip – Downloaded 66 times – 2 MB




Be the first to comment

Leave a Reply