Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Series fill of "patchy" Data set or some Programming fix
In a nutshell:
To Automaticaly ascribe (copy) to all cells with no value (within a column) that value contained in the nearest populated cell above. In detail: I have a "full~ish" column of non-contigious data in an excel wooksheet that I wish to automatically fill the gap cells with the value of the nearest non-empty cell above and continue doing this to the last row of data or the end of the file. Thank you in anticipation |
#2
|
|||
|
|||
Try this..
Highlight the cells that contain the data, ensuring that the first cell contains a value. select Edit - Goto - Special Select Blanks. Click OK All of the blank cells in your range should now be selected. The first blank cell should be active (assume this is A4). in the formula bar type in =A3 and then press Ctrl+Enter This will copy the value of the cell above in to all the blank cells in your range. Hope this helps. Nick "Ravvy" wrote in message ... In a nutshell: To Automaticaly ascribe (copy) to all cells with no value (within a column) that value contained in the nearest populated cell above. In detail: I have a "full~ish" column of non-contigious data in an excel wooksheet that I wish to automatically fill the gap cells with the value of the nearest non-empty cell above and continue doing this to the last row of data or the end of the file. Thank you in anticipation |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
QUESTION- Simpler Way to Add a Data Series to Other Graphs? | Excel Discussion (Misc queries) | |||
fill series | Excel Discussion (Misc queries) | |||
I've created a custom fill series. Now I don't know how to use i. | Excel Discussion (Misc queries) | |||
Format Data Series Markers | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |