Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default sorting multiple columns

I have multiple addresses on a work sheet. I need to have all the same zip
code # together. How do I sort them by zip code so right name and address
ends up with right zip code
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default sorting multiple columns

Highlight the range you want to sort before starting it.

Regards,
Fred

"arbe" wrote in message
...
I have multiple addresses on a work sheet. I need to have all the same zip
code # together. How do I sort them by zip code so right name and address
ends up with right zip code


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default sorting multiple columns

Pre-select all the columns before sorting on Zip Code.


Gord Dibben MS Excel MVP

On Wed, 17 Feb 2010 12:16:02 -0800, arbe
wrote:

I have multiple addresses on a work sheet. I need to have all the same zip
code # together. How do I sort them by zip code so right name and address
ends up with right zip code


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
sorting multiple columns Amstro2006 Excel Worksheet Functions 5 November 7th 07 10:07 PM
Sorting Multiple Columns SGF1 Excel Discussion (Misc queries) 3 October 6th 07 09:10 PM
Sorting multiple columns Hexius New Users to Excel 3 April 18th 06 01:55 AM
Sorting in multiple columns jezzica85 Excel Discussion (Misc queries) 2 February 20th 06 11:17 PM
Sorting multiple columns together sweetledee Excel Discussion (Misc queries) 4 August 23rd 05 10:19 PM


All times are GMT +1. The time now is 09:51 AM.

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

About Us

"It's about Microsoft Excel"