I have Excel 2007 and am trying to sort data by mutliple leves.
There are several column headers - the first two being First Name and Last Name. I've asked Excel to "Sort By" First Name and "Then By" Last Name, but the Last Name colum never organizes itself.
I have three people named Tom - Activo, Davidson, and Grife. When I sorted the data, Excel grouped all of the Toms together, but it has them in this order - Activo, Grife, and then Davidson. I'm assuming this is the order the names were embeded within the rest of the data prior to my sort. I can't understand, though, why the last name column isn't sorting as well.
Any ideas?
Thanks,
Magus