Excel Forum

Excel Magic Trick #203: Sequential Numbers in Formulas ROWS function

See how to create sequential numbers in formulas using the ROWS function. See the advantages of using this ROWS function method over other methods. See 4 different formula examples of this trick.
See the ROWS, ROW, and IF functions in various formulas.

Incrementing Numbers in Formulas. ROWS COLUMNS functions.

Got a Question? Ask it Here in the Forum.