A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Setting up and Configuration of Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I sort a table by last name and first name in Excel?



 
 
Thread Tools Display Modes
  #1  
Old December 1st 06, 09:32 PM posted to microsoft.public.excel.setup
Kubbybear18
external usenet poster
 
Posts: 1
Default How do I sort a table by last name and first name in Excel?

I have a table of business contacts that contains information such as last
name, first name, category, and company.

I would like to sort the table according to the last names, then first name,
then category, and finally company. I highlighted all the cells that have
information in them, then I used the "Sort" function in the "Data" menu. Then
I filled out the pop-up box with "sort by" -> last name, "then by" -> first
name, "then by" -> category. Then I click "ok".

But only the "last name" column gets sorted, not the rest.

I would like to sort it by last name, first name, category, and then
company. But if I sorted each column separately, the last names don't match
with the first name and the rest of the other information.

Thank you.
Ads
  #2  
Old December 2nd 06, 02:42 PM posted to microsoft.public.excel.setup
kassie
external usenet poster
 
Posts: 269
Default How do I sort a table by last name and first name in Excel?

Not clear what you are trying to achieve?

If you sort first by last name, the only time you will notice a sort by
first name as well, is when eg you have two or more people with the same
surname. Smith, Paul; Smith Jphn and Smith, Andy, will then sort as Smith
Andy; Smith, John and Smith Paul. Similarly, the only time that you will see
a category sort in this way, Is where you have two or more customers with the
same Last name, AND same first name, but different categories, eg if you have
3 Smith, Andy customers, they will then sort by category eg large; small;
small.

If you want to sort by Last Name, that's fine. If you then want to sort by
first name, select the entire range again, and click on Data; Sort; select
First Name. If you want to sort by Category, repeat this, but with Category
as your criteria.

If you reverse your order, and first sort by category, then by first name
and then by last name, you'll have a different result again. At least you
will be able to see that it actually sorted!

"Kubbybear18" wrote:

> I have a table of business contacts that contains information such as last
> name, first name, category, and company.
>
> I would like to sort the table according to the last names, then first name,
> then category, and finally company. I highlighted all the cells that have
> information in them, then I used the "Sort" function in the "Data" menu. Then
> I filled out the pop-up box with "sort by" -> last name, "then by" -> first
> name, "then by" -> category. Then I click "ok".
>
> But only the "last name" column gets sorted, not the rest.
>
> I would like to sort it by last name, first name, category, and then
> company. But if I sorted each column separately, the last names don't match
> with the first name and the rest of the other information.
>
> Thank you.

  #3  
Old December 2nd 06, 02:47 PM posted to microsoft.public.excel.setup
kassie
external usenet poster
 
Posts: 269
Default How do I sort a table by last name and first name in Excel?

Sorry, I forgot to mention. Do not sort on one column only, when selecting
only that column. Select the entire data range, say A167, and then sort by
column A, B, C or D. otherwise you will mess up yor data!

"Kubbybear18" wrote:

> I have a table of business contacts that contains information such as last
> name, first name, category, and company.
>
> I would like to sort the table according to the last names, then first name,
> then category, and finally company. I highlighted all the cells that have
> information in them, then I used the "Sort" function in the "Data" menu. Then
> I filled out the pop-up box with "sort by" -> last name, "then by" -> first
> name, "then by" -> category. Then I click "ok".
>
> But only the "last name" column gets sorted, not the rest.
>
> I would like to sort it by last name, first name, category, and then
> company. But if I sorted each column separately, the last names don't match
> with the first name and the rest of the other information.
>
> Thank you.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.