Hello Friends! I'm new to using what I believe are called dynamic functions in Excel. I have successfully used the INDIRECT function in this same sheet like this:
Obviously, this will return a numeric value.
Now, trying to get a unique list of text like this:
This results in a #VALUE! error with the details stating "A value used in the formula is of the wrong data type."
What I'm expecting is to get multiple results that 'spill' into the cells below the formula cell.
The format of all cells involved is 'General'. (If that makes any difference.)
What I'm trying to accomplish here is to account for sheets being added to this worksheet, then the tblSheets named range can be adjusted without having to rewrite several formulas.
I'm about five hours into reading about how to use the two functions in this formula and haven't made any progress. Suggestions are appreciated.
-Many Thanks!!
Excel Formula:
=SUMPRODUCT(SUMIF(INDIRECT("'"&tblSheets&"'!AG7:AG26"),K7,INDIRECT("'"&tblSheets&"'!AW7:AW26")))
Now, trying to get a unique list of text like this:
Excel Formula:
=UNIQUE(INDIRECT("'"&tblSheets&"'!AG31:AJ40"))
What I'm expecting is to get multiple results that 'spill' into the cells below the formula cell.
The format of all cells involved is 'General'. (If that makes any difference.)
What I'm trying to accomplish here is to account for sheets being added to this worksheet, then the tblSheets named range can be adjusted without having to rewrite several formulas.
I'm about five hours into reading about how to use the two functions in this formula and haven't made any progress. Suggestions are appreciated.
-Many Thanks!!