Simple sorting

%3CLINGO-SUB%20id%3D%22lingo-sub-1624028%22%20slang%3D%22en-US%22%3ESimple%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1624028%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%26nbsp%3B%20a%20worksheet%20with%20only%20three%20columns%3A%20Name%2C%20Ticket%20Number%2C%26nbsp%3B%20and%20Amount.%20When%20I%20sort%20on%20name%2C%20the%20amount%20column%20is%20no%20longer%20in%20sync%20with%20the%20name.%20So%20the%20amount%20associated%20with%20the%20name%20is%20incorrect.%20How%20do%20I%20sort%20on%20name%20an%20maintain%20the%20correct%20amount%20associated%20with%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1624028%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1624263%22%20slang%3D%22en-US%22%3ERe%3A%20Simple%20sorting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1624263%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F777421%22%20target%3D%22_blank%22%3E%40jwhllc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20sort%20all%20of%20the%20columns%20at%20the%20same%20time%2C%20based%20on%20the%20name%2C%20they%20should%20be%20staying%20in%20sync.%20However%2C%20if%20there's%20a%20calculation%20involved%20in%20the%20amount%2C%20and%20there%20are%20references%20to%20other%20cells%20or%20other%20sheets%20in%20the%20formulas%20that%20do%20those%20calculations%2C%20that%20could%20be%20changing%20the%20amounts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20question%20for%20you%3A%20do%20you%20NEED%20to%20sort%3F%20If%20you're%20looking%20for%20a%20given%20name%20and%20just%20alphabetizing%20to%20facilitate%20the%20search%2C%20you%20could%20search%20and%20retrieve%20it%20by%20other%20means%3A%20(FILTER%20as%20a%20function%2C%20if%20you've%20got%20the%20newest%20version%20of%20Excel)%20or%20the%20Filter%20action%20from%20the%20Data%20toolbar.%20There%20also%20are%20data%20retrieval%20functions%2C%20if%20you%20haven't%20got%20the%20newest%20Excel.%20DGET%2C%20for%20example.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have  a worksheet with only three columns: Name, Ticket Number,  and Amount. When I sort on name, the amount column is no longer in sync with the name. So the amount associated with the name is incorrect. How do I sort on name an maintain the correct amount associated with it?

1 Reply
Highlighted

@jwhllc 

 

If you sort all of the columns at the same time, based on the name, they should be staying in sync. However, if there's a calculation involved in the amount, and there are references to other cells or other sheets in the formulas that do those calculations, that could be changing the amounts.

 

A question for you: do you NEED to sort? If you're looking for a given name and just alphabetizing to facilitate the search, you could search and retrieve it by other means: (FILTER as a function, if you've got the newest version of Excel) or the Filter action from the Data toolbar. There also are data retrieval functions, if you haven't got the newest Excel. DGET, for example.