Not entirely sure I follow... not a function I use myself I confess but I think the data points of the latter range must match that of the former...
=FORECAST(71,F832:F901,ROW(INDEX(F832:F901,0))-(ROW(F832)-1))
Not entirely sure I follow... not a function I use myself I confess but I think the data points of the latter range must match that of the former...
=FORECAST(71,F832:F901,ROW(INDEX(F832:F901,0))-(ROW(F832)-1))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks