ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SQL.REQUEST Calculation Order (https://www.excelbanter.com/excel-programming/327122-sql-request-calculation-order.html)

Ryan Smith[_3_]

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