Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I Delete blank cells in a row | Excel Discussion (Misc queries) | |||
delete error/blank cells | Excel Worksheet Functions | |||
Using a function to delete blank cells | Excel Worksheet Functions | |||
Aladin...HELP!!! Running Averages of last 10 data entries, excluding blank cells | Excel Worksheet Functions | |||
Aladin...HELP!!! Running Averages of last 10 data entries, excluding blank cells | Excel Worksheet Functions |