Forum Discussion

ScottF123's avatar
ScottF123
Copper Contributor
Aug 04, 2022
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.

     

  • dscheikey's avatar
    dscheikey
    Bronze Contributor

    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.

     

    • ScottF123's avatar
      ScottF123
      Copper Contributor
      Thank you dscheikey!

      Looks good. I have the LET() function so I will try to apply it to my dataset now. Thanks for your help!

Resources