S
sticky
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.
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.