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

M

Mar

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?
 
R

Ron Rosenfeld

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?
Click to expand...

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
 
Top