Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying just the summarized data
Hello:
I have an Excel spreadsheet that averages several rows of data. Just like any sort of function such as averaging and summing, Excel has the summarized data within row numbers that are not continuous. For example, this spreadsheet (after row 1) begins with row 4, the next row is 9, the next row is 14, the next row is 17, etc. I'd like to copy this spreadsheet and paste the summarized values into another so that I have continuous row numbers (1, 2, 3, 4, etc.) of the summarized (averaged data). Is that possible to do? I have tried Copy....Paste Special. But, that has not worked. Thanks! childofthe1980s |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying just the summarized data
Nevermind....I figured it out as follows:
once you hit "2" in the upper left-hand corner, highlight the range you get, then CTRL G, Special, Visible cells only, copy, then paste it in your desired location childofthe1980s "childofthe1980s" wrote: Hello: I have an Excel spreadsheet that averages several rows of data. Just like any sort of function such as averaging and summing, Excel has the summarized data within row numbers that are not continuous. For example, this spreadsheet (after row 1) begins with row 4, the next row is 9, the next row is 14, the next row is 17, etc. I'd like to copy this spreadsheet and paste the summarized values into another so that I have continuous row numbers (1, 2, 3, 4, etc.) of the summarized (averaged data). Is that possible to do? I have tried Copy....Paste Special. But, that has not worked. Thanks! childofthe1980s |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying just the summarized data
The easy method is to sort the rows and the blank rows will end up at the bottom of the data. -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=146815 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table WITHOUT summarized data | Excel Discussion (Misc queries) | |||
repeated conversion of data summarized into rows and columns | Excel Discussion (Misc queries) | |||
Create summarized date driven data | Excel Discussion (Misc queries) | |||
Extract Data into a Summarized form | Excel Programming | |||
How do I change how PivotChart data is summarized, from sum to av. | Excel Worksheet Functions |