Macworld: Sorting a list by last name, not first ...

Up to Discussions in Business Mac

This Question is Answered

2 "helpful" answers available (2 pts)

4 Replies Last post: Nov 18, 2008 1:04 PM by weld

weld

161 posts since
Jul 3, 2002

Nov 15, 2008 5:09 PM

Sorting a list by last name, not first

I have a long list of students. Each student's name is in a separate cell, first name first and last name last: "Susan Smith," for example, and not "Smith, Susan." They're all in one column; I'd rather not have the first and last names in separate, adjacent columns, nor do I want to put the last name first. Is there any way to alphabetize this list by last name?

Skybolt

482 posts since
Jul 23, 2002

1. Nov 17, 2008 7:00 AM

in response to: weld

Re: Sorting a list by last name, not first

What software are you using? In some software, you can choose to sort by the "second field" and this may be available in your package. But we would need to know in order to help you.

weld

161 posts since
Jul 3, 2002

2. Nov 17, 2008 1:00 PM

in response to: Skybolt

Re: Sorting a list by last name, not first

Good point--don't know why I forgot to mention that in the original post. I'm using Excel (not the latest version but the previous one; Office 2004?).

mdawson

3,710 posts since
Aug 31, 2004

3. Nov 17, 2008 5:31 PM

in response to: weld

Re: Sorting a list by last name, not first

weld wrote:

Is there any way to alphabetize this list by last name?

Short answer: no. Despite their processing power, computers are incredibly stupid and must be explicitly told what to do.

What you or I would recognize as names, a computer only sees as nothing more than a string of text. Therefore, short of writing a VBA macro you have no option but to either put the first and last names into separate columns, place the names in the “Last, First MI” format or create a sorting column with the names in the latter format. The case would be no different if you were using dedicated database software either; hence, the reason Apple needed to add explicit sorting tags to complement certain tags (e.g., Artist, Album Artist, Album, etc.) in iTunes so that information can be properly grouped/sorted and display as expected.

“Cannot run out of time. There is infinite time. You are finite. Zathras is finite. This is wrong tool.” 2.3GHz Power Mac G5/8GB/2x1TB HDD/OS X 10.4.11/30-inch ACD, 60GB iPod (Color)

weld

161 posts since
Jul 3, 2002

4. Nov 18, 2008 1:04 PM

in response to: mdawson

Re: Sorting a list by last name, not first

Thanks, mdawson. I don't know whether that's the correct answer, but it sure sounds authoritative, so I'll designate it as the correct answer and resign myself to one of the approaches you listed.

Go to original post

Name	City

Address 1	State	Zip

Address 2	E-mail (optional)

This Question is Answered

Nov 15, 2008 5:09 PM

Sorting a list by last name, not first

Actions

More Like This