I need to alphabatize a excel spreadsheet by first name and last name. However, I also need the data in the other columns coresponding with the persons row to change with it as well. For example I know how to make the last and first name become alphabitized in this senerio, however it doesn't change the other two columns:
Smith, Jane $92 Filed
Smith, Kayla $07 Unfiled
Smith, Alle $12 Unfiled
So if i alphabetized this it would be:
Smith, Alle $92 Filed
Smith, Kayla $07 Unfiled
Smith, Jane $12 Unfiled
and not how I want it to be:
Smith, Alle $12 Unfiled
Smith, Kayla $07 Unfiled
Smith, Jane $92 Filed
Make sense? I have 300 pages to alphabatize so please give me the easiest way! Thanks!
Bookmarks