Home |
Search |
Today's Posts |
#1
|
|||
|
|||
post code on col1 & list of suburbs in col2 - what is the formula
|
#2
|
|||
|
|||
|
#3
|
|||
|
|||
"Peo Sjoblom" wrote: Hi Peo sorry,it did not 'll review the question - may be u can give me a formula 1. row1 -10 contain same post code number 2. row 1-10 contains names of the various post code 3.can you please help me with a formula where single post code combines all the suburbs in a cell separated by a formula 4. please note that number of suburbs (text) in a single post code varies need ur help thanks varun |
#4
|
|||
|
|||
"Peo Sjoblom" wrote: Sorry Peo should read separated by a comma |
#5
|
|||
|
|||
Sorry, I don't understand your question, same postcode in all rows?
can you give an example like postcode sub postcode sub postcode sub postcode sub postcode sub -- Regards, Peo Sjoblom (No private emails please) "varun" wrote in message ... "Peo Sjoblom" wrote: Hi Peo sorry,it did not 'll review the question - may be u can give me a formula 1. row1 -10 contain same post code number 2. row 1-10 contains names of the various post code 3.can you please help me with a formula where single post code combines all the suburbs in a cell separated by a formula 4. please note that number of suburbs (text) in a single post code varies need ur help thanks varun |
#6
|
|||
|
|||
what is the original data locations, example. You have to describe
exactly what you have, and what you want. However you will probably find what you need to answer your question in http://www.mvps.org/dmcritchie/excel/join.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "varun" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Cleaning Product Code list | Excel Worksheet Functions | |||
How do I add an area code to a list of phone numbers in Excel? | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Code Post: Extract Trendline coefficients | Excel Discussion (Misc queries) |