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.
Is this possible?

I don't fully understand your question, but you may want an absolute
reference (e.g. Change =A1 to be =$A$1 which means the formula never
changes when moved/copied), or don't sort the column containing the
formulas.
Clive


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=535872

The column containing the formula in let´s say A1, HAS do be moved (sorted),
but the formula in cell Q8 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?
(Something similar as "COUNTIF")

There are other

Thank you

Felix

"Clivey_UK" wrote:


I don't fully understand your question, but you may want an absolute
reference (e.g. Change =A1 to be =$A$1 which means the formula never
changes when moved/copied), or don't sort the column containing the
formulas.
Clive


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=535872

If you are just generating a table to be sorted for reports you could make
a copy of your worksheet to sheet2 then convert sheet2 to values,
do you sort on sheet2 and your report from sheet2. You would only
update sheet1 and report from sheet2 after preparing it from sheet1.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"fak119" wrote in message ...
The column containing the formula in let´s say A1, HAS do be moved (sorted),
but the formula in cell Q8 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?
(Something similar as "COUNTIF")

There are other

Thank you

Felix

"Clivey_UK" wrote:


I don't fully understand your question, but you may want an absolute
reference (e.g. Change =A1 to be =$A$1 which means the formula never
changes when moved/copied), or don't sort the column containing the
formulas.
Clive


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=535872