Sorting Values Without Sorting Formulas
 

Is there a way to sort values from several rows that were calculated using
formulas without disturbing the sequence of the formulas?

After the sort I would like for the formulas to be in the same place before
the sort and I would also like for th sorted values to be recalculated from
the formulas that remained in sequence.

Thanks in advance

Sorting Values Without Sorting Formulas
 

That is the default behavior...
To test
Enter some data in Col A then enter
=A1
in B1 and copy down

Sort on Col A & B...
Change some values in Col A and see...
--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"SBX" wrote:

Is there a way to sort values from several rows that were calculated using
formulas without disturbing the sequence of the formulas?

After the sort I would like for the formulas to be in the same place before
the sort and I would also like for th sorted values to be recalculated from
the formulas that remained in sequence.

Thanks in advance

Sorting Values Without Sorting Formulas
 

Thank you very much. This was very helpful.

"Sheeloo" wrote:

That is the default behavior...
To test
Enter some data in Col A then enter
=A1
in B1 and copy down

Sort on Col A & B...
Change some values in Col A and see...
--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"SBX" wrote:

Is there a way to sort values from several rows that were calculated using
formulas without disturbing the sequence of the formulas?

After the sort I would like for the formulas to be in the same place before
the sort and I would also like for th sorted values to be recalculated from
the formulas that remained in sequence.

Thanks in advance