Simple sorting

Copper Contributor

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

@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.