AMC
Registered User
I'm having sort issues in Excel. I have four columns: A: Name, B: Data1, C: Data2, D: Data3. I want to sort by Data3. However, D consists entirely of formulas drawing data from different cells in B and C. For example, cell D16 needs to get the total from C4 and B19. If I just sort by D, it messes up my data because what is in C4 and B19 changes. This is also a working file, so I need to be able to go to, say, Name in A19, change the value in B19, which changes the value in the D cells that relate to B19. Then I need to sort by D so that the names and the totals in Data3 line up.