Forum Discussion
Solved
Interpolating values between two dates
Hi,
I hope you are all well!
I currently have a dataset containing monthly financial data and quarterly financial data. I wish to linearly interpolate the quarterly data to monthly data so I can conduct some analysis between the two sets of financial data. I was using the excel 'fill' function to fill the blank cells as a linear trend but the full dataset spans 15 years; I found this process quite slow since I could only fill 2/3 months at a time. I'm looking for a more efficient way to complete this task.
I have attached a screenshot of some of the dataset which should help explain my situation. As you can see I have filled 'Div. Growth' using the excel 'fill' function but given the frequency of the data in the dataset I can only interpolate 2-3 cells at a time.
All help is appreciated!
Thanks!
HiScottF123,
I would create an auxiliary column with a formula that outputs the interpolated values. You could then save these values in your table (only copy them as values).
I have made an example. I hope you already have the LET() function, because I used it in my interpolation formula.
Have a look at the file to see if it comes close to your ideas.
HiScottF123,
I would create an auxiliary column with a formula that outputs the interpolated values. You could then save these values in your table (only copy them as values).
I have made an example. I hope you already have the LET() function, because I used it in my interpolation formula.
Have a look at the file to see if it comes close to your ideas.
