Hi,
Does anyone know an alternative (non-volatile) to the INDIRECT function.
I'm using the INDIRECT function to read a dynamic defined range
=SUM(INDIRECT(INDEX(ADDRESS(MATCH("y_" & $H39;$H:$H;0);COLUMN(K33));; ) & ":" & INDEX(ADDRESS(MATCH("y_" & $H39;$H:$H;0);COLUMN(K$33)+(MID($G$33;2;4)-K$3-1));; )))
..But because its volatile it works quite slow. So i'm looking for a replacement for the INDIRECT formula, since the INDEX and SUM can't read a dynamic (text) defined range... ???
Thanks !
Does anyone know an alternative (non-volatile) to the INDIRECT function.
I'm using the INDIRECT function to read a dynamic defined range
=SUM(INDIRECT(INDEX(ADDRESS(MATCH("y_" & $H39;$H:$H;0);COLUMN(K33));; ) & ":" & INDEX(ADDRESS(MATCH("y_" & $H39;$H:$H;0);COLUMN(K$33)+(MID($G$33;2;4)-K$3-1));; )))
..But because its volatile it works quite slow. So i'm looking for a replacement for the INDIRECT formula, since the INDEX and SUM can't read a dynamic (text) defined range... ???
Thanks !
Last edited by a moderator:
