sorting by first column then by second column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when I use data sort for two columns (Last Name, First Name) why is the
second column not alphabetically correct? John before Betty with both having
a last name of Andrews?
 
BAENOW, when I sorted, it worked correctly. You might check to see if you
have any leading spaces in the names using the Len function. If you do, you
can get rid of them with the Trim function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Columns not sorting properly. 2
How do I separate first and last names into two columns? 2
Excel Comparing two columns 1
Alphabetize in multiple columns 2
Sorting 2
Matching Names 5
Sorting 1
multiple column sort in a pivot table 6

Back
Top