Think about restructuring your formulae to use offset/index/match etc. - there may be a workaround this way (without seeing data is hard to know...)
CC
Think about restructuring your formulae to use offset/index/match etc. - there may be a workaround this way (without seeing data is hard to know...)
CC
CC, in this instance the use of INDIRECT is more to do with creating dynamic external links within other formulae.
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