LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Robert Lundqvist
 
Posts: n/a
Default Replacing missing values?

I have this fairly large dataset with two kinds of missing values (NA):

1) Holes should be filled with the first before the sequence of
missing values (i e a constant level up to next value)

From: ...30 31 29 NA NA NA 31 32 NA 34
to: ...30 31 29 29 29 29 31 32 32 34

2) Holes shold be filled by a linear interpolation based on the values
between holes.

From: ...30 31 29 NA NA NA 31 32 NA 34
to: ...30 31 29 29.5 30.0 30.5 31 32 33 34

Any chance this could be achieved by macros? Any ideas are most welcome.

Robert
********************
Robert Lundqvist
Dept of mathematics
Lulea University of Technology
Sweden

http://www.ltu.se/web/pub/jsp/polopo...d=4171&a=10697

 
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
ignore missing values while ploting graph Excel plot Excel Discussion (Misc queries) 2 September 15th 05 06:48 PM
list missing values in a sequence matt Excel Discussion (Misc queries) 3 September 12th 05 06:36 PM
Inserting and Tracking Missing Sequence matt Excel Discussion (Misc queries) 2 September 12th 05 04:26 AM
Excel Compare values in columns & display missing values in a new cpetta Excel Discussion (Misc queries) 1 April 2nd 05 05:51 AM
How do I stop excel replacing numerical values with the date? Becca C Excel Discussion (Misc queries) 2 December 21st 04 12:12 PM


All times are GMT +1. The time now is 05:50 AM.

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"