It is true that you can't use INDIRECT with DNRs. You can use it with tables though, or you can define a name that uses the old EVALUATE XLM function (though you have to use a macro-enabled workbook format in that case).
It is true that you can't use INDIRECT with DNRs. You can use it with tables though, or you can define a name that uses the old EVALUATE XLM function (though you have to use a macro-enabled workbook format in that case).
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks