Excel 2010 Sorting on formula result

[jak26]

I think im going nuts

How do you sort your data largest to smallest based on the result of a formula? Ie look at values not formula

At present when I sort the data it is sorting by the cell reference

Thanks

 

[Gerald Higgins]

Hi.

Excel normally does sort on the formula result, but what may happen is that the act of sorting may change the results for some or all of the formulas.

Try turning calculation to manual to see if this is your problem.

Set calculation to manual, do the sort, look at the results (which should be based on formula result), then calculate (either using f9, or by setting calculation back to automatic) and if the results then change, then that's your problem.

 

[jak26]

You are correct.

the infuriating inability to find the answer on google clouded my reasoning
Cheers