sorting columns with formulas

  • Thread starter Thread starter still learning
  • Start date Start date
S

still learning

How do I sort columns, which have data that is being used in formula
in a different column, without any of the values changing afte
sorting
 
Only way I know of would be to turn the formulas into values by copy and
paste special as values


Regards,

Peo Sjoblom
 
You must log in or register to reply here.

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

Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1
Using a drop-down box to sort data based on seperate columns 2
Sort cells and "Place in this document"-hyperlinks 1
MACRO RUN random percentage and copy of column values 1
Mailing address block: sorting 1 row to columns 1
Auto Sort 1 column and select data 4
Data Sort Unique 5
count runlengths 6

Back
Top