Forum Discussion
Simple sorting
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 inc...
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.