I need to create a formula that can update when new entries and entered in
the rows of a single page spreadsheet.
Here is the problem. This is a standardized format for my office so all I
can do is fix their equation. The prior year numbers are on the 2nd row of
the spreadsheet, and they enter new entires in successive rows on the form so
that they can track staff strength numbers on a weekly basis for the entire
year. They want an equation that will recompute the weekly comparison to the
prior year's ttl number. I can't just use SUM because we're not tracking
growth. We're trying to track variation to the prior year, and each week the
cell I need to refer to for the current week's numbers changes because it is
one row lower.
So I need to figure out an equation that will allow me to refer to the last
cell in a column that has a value, and I need it to update as new values are
added in cells below the previous last cell to track those cells as the new
reference cells.
Thank you for your time.
--
Adapt, adjust and overcome.