Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 29th 09, 03:56 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 4
Default multicolumn adress file. want to sort on last , first name

how do i do it.

  #2   Report Post  
Old May 29th 09, 04:26 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default multicolumn adress file. want to sort on last , first name

Hi,
could you provide an example of your file

"bdcochran" wrote:

how do i do it.

  #3   Report Post  
Old May 29th 09, 05:59 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 4
Default multicolumn adress file. want to sort on last , first name



Last First Telephone Address Suite City State Zip Code Personal Notes

  #4   Report Post  
Old May 29th 09, 06:01 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 4
Default multicolumn adress file. want to sort on last , first name



"Eduardo" wrote:

Hi,
could you provide an example of your file

"bdcochran" wrote:

how do i do it.

Last First Telephone Address Suite City State Zip CodePersonal Notes

  #5   Report Post  
Old May 29th 09, 06:10 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 2,276
Default multicolumn adress file. want to sort on last , first name

Hi,
Insert and empty row between the titles and the first row with Data, then
highlight the total range from the column containing the Last name to the one
containing the notes, then go to Data Sort and select the column which have
the last name choose Ascending or descending

If this helps please click yes, thanks

"bdcochran" wrote:



"Eduardo" wrote:

Hi,
could you provide an example of your file

"bdcochran" wrote:

how do i do it.

Last First Telephone Address Suite City State Zip CodePersonal Notes



  #6   Report Post  
Old May 29th 09, 06:47 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 4
Default multicolumn adress file. want to sort on last , first name


Last First Telephone Address Suite City State Zip CodePersonal Notes

I have multiple people with the same last name. I want to alphabetize the
list so that the information is by last name and then the multiple people
with the same last name have their information in first name order. I cannot
figure out how to do descending on two columns at the same time. Yeah, I can
alphabetize by last name alone. Then the first names are in random order.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
error with adress function denbee Excel Discussion (Misc queries) 2 July 16th 08 08:48 PM
Transferring items between multicolumn listboxes [email protected] Excel Discussion (Misc queries) 2 September 28th 07 03:09 PM
Can Excel Adress Envelopes? Donald Excel Worksheet Functions 1 September 20th 06 07:52 PM
SUM using results from an Adress-formula Langbraten Excel Discussion (Misc queries) 3 March 31st 06 01:01 PM
How do I print my adress list? Andreas Excel Discussion (Misc queries) 2 April 4th 05 02:31 PM


All times are GMT +1. The time now is 10:16 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017