How do I sort a column of computed variables in EXCEL?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to sort a column of character variables which have been computed by a
formula. The formula is VLOOKUP(....._). The standard sort routine does not
work because each cell contains the fomula used to arrive at the variable
rather than the variable itself. Is there a way I can copy the column and
retain the actual entries rather than the formula?
 
Is the VLOOKUP not working or are you trying to paste the
results somewhere else. If the later use Copy, paste special values

Otherwise, you will need to explain what you have and what is happening.
 
Sylgeox, copy, edit, paste special, check valves. If you don't want to write
over your data, pick another place to paste the data then edit, paste
special, check valves

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
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

HLOOKUP using variable columns 5
Excel Calculations 2
How do I group and transpose data - macro help needed. 4
How do I sort between worksheets depending on variable 1
using hlookup to reference a column in a vlookup formula? 3
Countif formulas change after doing a sort 3
How do I arrange columns alphabetically by column label? 1
How can I use circular references that are allowed in Lotus 123? 1

Back
Top