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 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
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" <[email protected]> wrote in message news:[email protected]...
> 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
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks