Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GAW GAW is offline
external usenet poster
 
Posts: 4
Default how to sort addresses in microsoft excel

I have 2 lists of addresses on one sheet. Most of the addresses are
duplicates and I want to sort them so it puts all the duplicates together.
The streets include the house number, as 1257 Rock St. I can sort them by
street alone but I need to sort by street and the address together, is there
a way to do this? I am using Excel 2000, 9.0.2720.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default how to sort addresses in microsoft excel

On Jul 17, 5:43*pm, GAW wrote:
I have 2 lists of addresses on one sheet. Most of the addresses are
duplicates and I want to sort them so it puts all the duplicates together..
The streets include the house number, as 1257 Rock St. I can sort them by
street alone but I need to sort by street and the address together, is there
a way to do this? I am using Excel 2000, * 9.0.2720.


if your address is always in the format of 1257 Rock. St, you can
split it into 2 columns, 1 for the number, 1 for the street
number =MID(I25, 1, SEARCH(" ", I25, 1)-1)
street =MID(I25, SEARCH(" ", I25, 1)+1, LEN(I25))

then use excel to sort by street column first, then by number column
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default how to sort addresses in microsoft excel

On Jul 17, 11:00*pm, recrit wrote:
On Jul 17, 5:43*pm, GAW wrote:

I have 2 lists of addresses on one sheet. Most of the addresses are
duplicates and I want to sort them so it puts all the duplicates together.
The streets include the house number, as 1257 Rock St. I can sort them by
street alone but I need to sort by street and the address together, is there
a way to do this? I am using Excel 2000, * 9.0.2720.


if your address is always in the format of 1257 Rock. St, you can
split it into 2 columns, 1 for the number, 1 for the street
number *=MID(I25, 1, SEARCH(" ", I25, 1)-1)
street * *=MID(I25, SEARCH(" ", I25, 1)+1, LEN(I25))

then use excel to sort by street column first, then by number column


to clarify, i25 was the cell containing the address in my test case
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
How do I sort mailing addresses in Excel? outfitterim Excel Discussion (Misc queries) 2 August 15th 06 11:07 AM
How do I sort addresses in excel? tapndog Excel Worksheet Functions 4 July 20th 05 03:49 AM
how can I use my e-mail addresses on excel xp with microsoft outlo Cat Excel Discussion (Misc queries) 1 April 22nd 05 12:10 PM
how can I use my e-mail addresses on excel xp with microsoft outlo paola Excel Discussion (Misc queries) 0 April 22nd 05 11:19 AM
how can I use my e-mail addresses on excel xp with microsoft outlo paola Excel Discussion (Misc queries) 0 April 22nd 05 11:19 AM


All times are GMT +1. The time now is 11:29 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"