how to delete blank cells between those with entries
You can get all the averages in a contiguous block of cells using a formula.
Just tell us what the range is.
Do you want something like this:
B1 = average of A1:A90
B2 = average of A91:A180
B3 = average of A181:A270
B4 = average of A271:A360
etc
etc
--
Biff
Microsoft Excel MVP
"dumchik" wrote in message
...
This is the set up. Column A has 2160 entries of daily data. Column B
has
been created by averaging consecutive sets of 90 entries in Column A,
entering those averages on every 90th row of Column. I need to copy the
values in Column B and collapse them, by deleting the 89 blank cells
between
each, at the same time. I know how to copy values as opposed to
functions--i
have forgotten how to get rid of the blanks between occupied cells.
|