Hi,
I have a multi tab spreadsheet, in one tab I have two columns name and income.
The name column has been input but the income column is populated using a sumifs formula from the other tabs in the spreadsheet. When I then try and sort the income column largest to smallest it does this but then a few seconds later reverts to the old order. I think this is because the formulas are recalculating?? Is this why and if so any way I can get the sort to stick?
i've never seen a sort reverting. could you possibly have vba in the file?
although it's not a reverting problem, but remove worksheet reference referring to the same sheet. that screws up the sort. for eg if your tabs are named Source and Dest. in the Dest worksheet, do not use:
=SUMIF(Source!A:A,Dest!A2,Source!B:B)
instead, use:
=SUMIF(Source!A:A,A2,Source!B:B)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks