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
|