Jul 1, 2015 · The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not permitted. If a user is believed to have used such tools to provide a forum answer, sanctions …

Dec 1, 2023 · Interpolating monthly data from yearly actuals Hi, I am trying to linear interpolate annual data into monthly. 2019 29,063,000 2020 31,388,000 2021 24,826,000 2022 …

Apr 21, 2020 · Re: Interpolate between dates Hi davsth, thanks again for the help on this. Just taken a closer look by plotting the interpolation vs the original date. At first glance I would have …

Mar 29, 2020 · Hi there, I'm in search for a formula that can perform linear interpolation between within arange of values. The case is best illustrated in the attached sheet. The formula need to …

Aug 5, 2022 · 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 …

May 7, 2013 · Re: VLOOKUP/INTERPOLATE Data Table to obtain Y given X and Z After studying this problem a bit more I think I can clarify a bit better what I am looking for. Calling the data …

Oct 7, 2017 · Re: 3 Variable Table Lookup with linear Interpolation Analysis can be refined by interpolation on any of the 3 values which I do on a regular bases but was trying to streamline …

Jan 18, 2013 · Re: Interpolate between data - NOT WORKING? Thank you MrShorty, that was indeed the issue (can't believe I missed that)! However, it doesn't seem as if my interpolation …

Aug 22, 2018 · I'm trying to use VLOOKUP and then interpolate my data to get what I want. The below is my look up table. I need to find the result (B) of a particular value (A). Say I have A as …

Jun 19, 2006 · I'm generally quite happy with how excel graphs the moderately non-linear x-y data I supply it - the curves pass through all the data points with a pleasing fit. I'd just like to be able …