Sorting in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1379625%22%20slang%3D%22en-US%22%3ESorting%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1379625%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3CBR%20%2F%3E%3CBR%20%2F%3EWhen%20i%20have%20a%20column%20where%20each%20cell%20is%20programmed%20to%20sum%20up%20the%20numbers%20in%20the%20row%20to%20the%20left%2C%20am%20I%20then%20able%20to%20have%20it%20automaticly%20sort%20from%20highest%20to%20lowest.%20Or%20do%20I%20constantly%20have%20to%20sort%20the%20column%20again%20manualy%20as%20new%20numbers%20are%20summed%20up%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1379625%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Hi!

When i have a column where each cell is programmed to sum up the numbers in the row to the left, am I then able to have it automaticly sort from highest to lowest. Or do I constantly have to sort the column again manualy as new numbers are summed up? 

3 Replies
Highlighted
you need to do it manually,
unless you use some macro to do it with every refresh
Highlighted
Thanks!
Highlighted
just for your reference, i found this on youtube: https://www.youtube.com/watch?v=TGSA1aXc4yE