| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specifying adjacent formulae for a QueryTable AutoRefresh's FillAdjacentFormulas
So, I have this query table. And next to its result range, I have a
number of derived column. The first one is the time difference from the initial record[like =(C43-C$3)], and the rest are rates of the form =(F43-F42)/($C43-$C42), where I see how quickly one value changed to another. The time column updates great. But, the refreshes ignore the other columns. Does only the first adjacent column ever get filled? Is there something I can do to get the other columns filled in? Thanks! Ion |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Set formulae to read the adjacent or next spreadsheet | Excel Worksheet Functions | |||
| displaying adjacent cell when using max/min formulae | Excel Worksheet Functions | |||
| Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
| reference adjacent cells in formulae | Excel Programming | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Threaded Mode
