View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TimE TimE is offline
external usenet poster
 
Posts: 1
Default Autofill missing numbers


Is it possible to autofill missing numbers? I will have a sampling a
data by date, but not all days will have data.

2/2/06______100
2/3/06
2/4/06
2/5/06______90
2/6/06______87
2/7/06
2/8/06______79


I would like the data for 2/3 and 2/4 to be filled
(incremented/decremented) in with the assumed data (in this case -
3.333333) and 2/7 with 83. The amount of missing days will be random.

Any help is greatly appreciated.

TimE


--
TimE
------------------------------------------------------------------------
TimE's Profile: http://www.excelforum.com/member.php...fo&userid=2139
View this thread: http://www.excelforum.com/showthread...hreadid=533561