Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Moving Formula
I want to use a formula in a cell (fixed), that contains a cell as reference
which in turn is subject to "move" by sorting. The column containing the formula in lets say A1, HAS do be moved (sorted), but the formula in cell Q8 (fixed there) should always refer to the value that was formerly in cell A1 and might now be in A5. This row 1 is part of a table that gets sorted. The line, that contains the value (in row 1) to be used in cell Q8 contains some fixed text, that never changes. Might this help? (Maybe something similar as "COUNTIF") Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
formula with moving range | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
pasting or moving formula cells without updating formulas | Excel Discussion (Misc queries) |