Sorting
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 |
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 . |
All times are GMT +1. The time now is 12:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com