sorting multiple columns

P

Pat

I have a very large spreadsheet, however, I want to sort
by Country, last and first.

It will sort by country with no problem, however when I
review the last name column, they are out of order. For
instance in the one country, when I check the last name,
a person with the last name starting with "G" came after
a person with the last name starting with a "T".

I'm not sure what I need to do to get this to work.
 
P

Peo Sjoblom

I cannot reproduce that, all my countries come out OK and within each
country all last names are sorted.
You have to select all the data, then sort by country, secondly by last name
and make sure both are ascending
 

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

Top