Sorting Values Without Sorting Formulas

S

SBX

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
 
S

Sheeloo

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...
 
S

SBX

Thank you very much. This was very helpful.

Sheeloo said:
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...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Moving Formulas when Sorting 2
replace all formulas with values in multiple worksheets 5
Printing a worksheet with and without formulas showing 1
Background stays when sorting 2
Sort on only portion of a column 2
what if analysis 3
How to show all formulas of cells in cells (and not the calculated result) ? 10
HELP! optimize calculating values 3

Top