Thread: Possible to auto-fill in gaps between numbers on straight line bas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sticky sticky is offline
external usenet poster
  
Posts: 1
Default Possible to auto-fill in gaps between numbers on straight line bas
Guys,

I have some time series data but with gaps in between. Is there a way to get
Excel to fill in the blanks between two numbers on a straight line basis?

Eg: If I have in A1 the number 5 and in A4 the number 11, is there a way to
automatically fill A2 with 7 and A3 with 9?

Thanks in advance.
Reply With QuoteReply With Quote