Sort by data, not by formula

M

MIKE

I am trying to sort data by the answer in a column that is
the result of a formula. How can I sort it by the result
rather than the formula without hiding the formula?
 
T

Tushar Mehta

I must be missing something, but XL always sorts by the value in a
cell. So, it would appear to me that you are trying to avoid something
that XL doesn't do in the first place.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

Cannot sort a table containing text 5
Newbie Help - IF Yes No Function 0
Copy addition formula of non-consecutive horizontal cells 2
Consolidation Table from Different Excel Tabs with Different Format 1
Convert Formula Results to Absolute 1
MS Project. Real progress of the project, % complete 1
excel 2011 won't sort alphabetically 7
how to sort correctly with this formula being used 2

Top