Sorry for this vague question, I don't know exactly how to formulate it with correct excel jargon.
I need to be able to sort this data after age and amount so that the names, date of birth, and specific amount follows the three people through different sorting. In other words, I need to make the specific data stick to each name, so that for example Eric will always be born 85/07/12 and have 500$ in the bank.
Name DOB Amount$
Eric 85/07/12 500
Chris 90/05/16 210
Tom 86/11/09 600
So that sorting after age from oldest to youngest would be:
Eric 85/07/12 500
Tom 86/11/09 600
Chris 90/05/16 210
Sorting after amount$ (High to low) would be
Tom 86/11/09 600
Eric 85/07/12 500
Chris 90/05/16 210
Do I do this through pivot tables or is there a specific command that makes the data stick to each individual?
Thank you.
Bookmarks