Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time calculation probolem request | Excel Discussion (Misc queries) | |||
calculation order | Excel Worksheet Functions | |||
Working days and hours calculation - request assistance please! | Excel Worksheet Functions | |||
Order of calculation | Excel Discussion (Misc queries) | |||
Order of Calculation | Excel Programming |