Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by Content
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by Content
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by Content
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 . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by Content
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" wrote in message ... 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 . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by Content
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" wrote in message ... 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" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting by Content
You might try using substring to isolate the last work in column A into a new
column. Then you can sort on the new column. "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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Content in one coulumn using given content in another | Excel Worksheet Functions | |||
Sorting and lining up data into columns based off content | Excel Discussion (Misc queries) | |||
copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
sorting, borders going with cell content | Excel Discussion (Misc queries) |