M
Mel
What fx to use for the following scenario:
Month-End Dates (for many years) in column A
A dollar Amount for each Quarter End in Column B (correlating to the
month-end date).
We would like a function to easily copy down column B that will interpolate
values in between the dollar amounts for each quarter end.
NOTE: The edit-fill-series>Trend works for a manual fix however we have
thousands and thousands of dates with quarter end dates so a faster approach
would be much more efficient.
Thanks for any guidance/expertise you may provide.
Mel
Month-End Dates (for many years) in column A
A dollar Amount for each Quarter End in Column B (correlating to the
month-end date).
We would like a function to easily copy down column B that will interpolate
values in between the dollar amounts for each quarter end.
NOTE: The edit-fill-series>Trend works for a manual fix however we have
thousands and thousands of dates with quarter end dates so a faster approach
would be much more efficient.
Thanks for any guidance/expertise you may provide.
Mel