Sorting
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
.
|