LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ravvy
 
Posts: n/a
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
QUESTION- Simpler Way to Add a Data Series to Other Graphs? phil6666 Excel Discussion (Misc queries) 0 February 10th 05 05:57 PM
fill series J. Kopp Excel Discussion (Misc queries) 1 February 1st 05 11:23 PM
I've created a custom fill series. Now I don't know how to use i. candybluevt Excel Discussion (Misc queries) 2 January 26th 05 08:48 PM
Format Data Series Markers KB Charts and Charting in Excel 1 November 30th 04 03:37 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"