this:
ROW(INDEX(F832:F901,0))-(ROW(F832)-1)
in the context of the FORECAST formula would generate an array of values {1 to 70}
To test / prove / visualise it ... put the above into the formula bar (with = obviously) and hit F9
this:
ROW(INDEX(F832:F901,0))-(ROW(F832)-1)
in the context of the FORECAST formula would generate an array of values {1 to 70}
To test / prove / visualise it ... put the above into the formula bar (with = obviously) and hit F9
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