Column Formula

admin4640

Is there a way to break up a column formula after a certain number of rows? We have an inventory column that is broken into 2 sections which are divided by a row.

For example: I'd like the first 100 rows to be one formula and the next 100 to be a different formula. I want to use a column formula instead of manual entering formulas because sometimes the numbers of those rows changes.

Paul Newcome

I would set it up like this:

Insert a Sheet Summary field called "Change Row" where you can manually enter the row number where you want the formula to change over.

Insert an auto-number column called "Auto" (formatting doesn't matter so can work if you already have this column in your sheet).

Insert a text/number column called "Row" with this column formula:

=MATCH(Auto@row, Auto:Auto, 0)

Then write out the formulas you want to transition between and nest them in an IF along the loines of

=IF(Row@row <= [Change Row]#, first_formula, second_formula)