From: Father John on
Hi

I have a spreadsheet with numerous addresses in col. A 1-999

15 Smith Street Jonestown
21 George Street Blacktown etc.

In col B. 1-166 I have the name of all the suburbs in our region

How can is sort col. A by suburb using the name of the suburbs in Col.B. ?

Any help much appreciated

Regards
Stephen

From: ozgrid.com on
I'm assuming you have blanks in Column "B" representing repeated Suburbs.
http://www.ozgrid.com/Excel/excel-fill-blank-cells.htm





--
Regards
Dave Hawley
www.ozgrid.com
"Father John" <w(a)b.com> wrote in message
news:2lsyn.19950$pv.11001(a)news-server.bigpond.net.au...
> Hi
>
> I have a spreadsheet with numerous addresses in col. A 1-999
>
> 15 Smith Street Jonestown
> 21 George Street Blacktown etc.
>
> In col B. 1-166 I have the name of all the suburbs in our region
>
> How can is sort col. A by suburb using the name of the suburbs in Col.B. ?
>
> Any help much appreciated
>
> Regards
> Stephen
>

From: JLatham on
From my reply in the duplicate post in Worksheet Functions:

select all of the cells involved in both columns (and any more with related
data), then use Data Sort and sort on Column B. To put the street addresses
in some kind of order within the suburb, choose Column A as the second sort
parameter.



"Father John" wrote:

> Hi
>
> I have a spreadsheet with numerous addresses in col. A 1-999
>
> 15 Smith Street Jonestown
> 21 George Street Blacktown etc.
>
> In col B. 1-166 I have the name of all the suburbs in our region
>
> How can is sort col. A by suburb using the name of the suburbs in Col.B. ?
>
> Any help much appreciated
>
> Regards
> Stephen
>
> .
>
From: Father John on
Hi there
I don't think this will work as it will sort the total suburbs in B and the
addresses by street number in A
The data in B does not align with col. A as B only contains the name of the
suburbs in the region
Thanks
Stephen


"JLatham" <JLatham(a)discussions.microsoft.com> wrote in message
news:09719682-5968-4D37-BDD4-95AEBA5B1CB1(a)microsoft.com...
> From my reply in the duplicate post in Worksheet Functions:
>
> select all of the cells involved in both columns (and any more with
> related
> data), then use Data Sort and sort on Column B. To put the street
> addresses
> in some kind of order within the suburb, choose Column A as the second
> sort
> parameter.
>
>
>
> "Father John" wrote:
>
>> Hi
>>
>> I have a spreadsheet with numerous addresses in col. A 1-999
>>
>> 15 Smith Street Jonestown
>> 21 George Street Blacktown etc.
>>
>> In col B. 1-166 I have the name of all the suburbs in our region
>>
>> How can is sort col. A by suburb using the name of the suburbs in Col.B.
>> ?
>>
>> Any help much appreciated
>>
>> Regards
>> Stephen
>>
>> .
>>

From: Father John on
No the problem is the data I want to sort the column by is contained within
the address - it is not the lead part of the data
Col B has the full list of the suburbs that I am trying to d the sort with
The data in col. B does not form a part of the record for each line
Thanks
Stephen


"ozgrid.com" <dave(a)ozgrid.com> wrote in message
news:86DB0FBA-0BCA-40D2-B164-BB958F5ADF64(a)microsoft.com...
> I'm assuming you have blanks in Column "B" representing repeated Suburbs.
> http://www.ozgrid.com/Excel/excel-fill-blank-cells.htm
>
>
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "Father John" <w(a)b.com> wrote in message
> news:2lsyn.19950$pv.11001(a)news-server.bigpond.net.au...
>> Hi
>>
>> I have a spreadsheet with numerous addresses in col. A 1-999
>>
>> 15 Smith Street Jonestown
>> 21 George Street Blacktown etc.
>>
>> In col B. 1-166 I have the name of all the suburbs in our region
>>
>> How can is sort col. A by suburb using the name of the suburbs in Col.B.
>> ?
>>
>> Any help much appreciated
>>
>> Regards
>> Stephen
>>
>