Excel Forum



Excel Magic Trick 692: More About Incrementing Numbers In Formulas


See how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the functions ROWS, INT, MOD, COLUMNS and more. Sequencing Numbers - Even Odd.

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm





Got a Question? Ask it Here in the Forum.