Prev: Lookup Question
Next: What does this formula mean [$-F400]h:mm:ssAM/PM
From: Father John on 17 Apr 2010 20:08
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 17 Apr 2010 21:05
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
>
> .
>
 | 
Pages: 1
Prev: Lookup Question
Next: What does this formula mean [$-F400]h:mm:ssAM/PM