setting a formula to apply to all rows in a column
The usual trick is to pre-fill with blanks
Let's say we want the formula to be
=A1+B1 and copy down the column
At some point we will run out of values in columns A&B. So instead we use:
=IF(A1="","",A1+B1) and copy all the way down
Now the formula will return blanks unless there is actual data in column A,
etc.
--
g.s. gsnu200701
"dave @ stejonda" wrote:
I want to set a simple (k-e) formula to apply to all rows in a column
rather than to a finite set of rows. This is because I want people to be
able to add an indefinite number of rows without the formula suddenly
stopping working. Is this possible? (I asked my work IT helpdesk but
they didn't know how to do it nor whether it was possible! :)
thanks folks,
--
dave @ stejonda
|