![]() |
SQL.REQUEST Calculation Order
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 |
All times are GMT +1. The time now is 10:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com