Excel 2010 Sorting on formula result

J

jak26

Board Regular
Joined
Dec 4, 2007
Messages
53
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
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Sort by date Sort by votes
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.
 
Upvote 0
You are correct.

the infuriating inability to find the answer on google clouded my reasoning
Cheers
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
Multi column data sorting problem
Replies
8
Views
310
Peter_SSs
Peter_SSs
D
  • Question Question
Sorting times in chronological order from a specific time
Replies
3
Views
227
Akuini
Akuini
N
  • Solved
Command buttons not sorting - and sometimes jumping around on sort
2
Replies
10
Views
139
netxtown
N
S
  • Solved
When Filter is applied, Excel jumps down multiple rows to (Blanks). How can Filter ignore blanks?
Replies
3
Views
304
Peter_SSs
Peter_SSs
E
  • Question Question
Find the First Number In a Table of Sorted Numbers That is Smaller Than Another Number
Replies
4
Views
313
Eb0la11
E

Forum statistics

Threads
1,223,937
Messages
6,175,514
Members
452,650
Latest member
Tinfish

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top