How can I sort by the value of my formula and not actual formula

's Computer Specifications

Everytime I sort, it sorts by the formula and I want it to sort by the value
of that specific formula. How can I get it to recognize my value as my
sorting option?

's Computer Specifications

On Wed, 26 Oct 2005 13:30:06 -0700, Mar <(E-Mail Removed)> wrote:

>Everytime I sort, it sorts by the formula and I want it to sort by the value
>of that specific formula. How can I get it to recognize my value as my
>sorting option?

It should do that unless you have entered the formula as TEXT.

If you are seeing "value" in the cell, it should be sorting by the "value".

If it does not appear to be doing that, post an example.

--ron

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel - Want to sort by formula value without losing formula	HappyPill	Microsoft Excel Misc	4	22nd Sep 2010 05:59 PM
Add the actual value in a cell that contains a formula	Alicia from Ft Lauderdale	Microsoft Excel Misc	3	21st Apr 2008 07:00 PM
Formula results to actual value	Jeff	Microsoft Excel Misc	3	23rd Nov 2007 08:00 PM
what is the 1 minus in this formula actual doing	=?Utf-8?B?S2ltIFNoZWx0b24gYXQgUERD?=	Microsoft Excel Worksheet Functions	2	21st Nov 2006 05:08 PM
Getting result of formula instead of actual formula	LoDawg	Microsoft Excel Programming	2	20th Sep 2006 12:52 PM