R
Ryan Smith
I am trying to create a sheet with a number of SQL.REQUEST statements.
C1:AL1 is the result of a SQL.REQUEST array.
I would like to then have the remainder of each column be a SQL.REQUEST,
based on the contents of the (col)1 cell.
Everything seems to work, except that I seem to be calculating fields
out of order. If, for example, C7 is empty, an IF statement in C18
should recognize that. For some reason, though, C18 is evaluated before
C7 is returned.
Is there a way to control the order and/or direction of the
auto-recalculations?
TIA
C1:AL1 is the result of a SQL.REQUEST array.
I would like to then have the remainder of each column be a SQL.REQUEST,
based on the contents of the (col)1 cell.
Everything seems to work, except that I seem to be calculating fields
out of order. If, for example, C7 is empty, an IF statement in C18
should recognize that. For some reason, though, C18 is evaluated before
C7 is returned.
Is there a way to control the order and/or direction of the
auto-recalculations?
TIA