Sorting Values Without Sorting Formulas

  • Thread starter Thread starter SBX
  • Start date Start date
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
 
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...
 
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

Can I sort and not lose reference to the cell? 3
Sorting percentages 2
sorting values 2
Excel - Want to sort by formula value without losing formula 4
sorted running balance 2
Data Sorting 1
Sorting Formulas 1
Sorting with Column has Formula 3

Back
Top