#1   Report Post  
varun
 
Posts: n/a
Default Post code & Suburbs

Hello Everyone

An u please suggest a formula to solve this problem

post code Suburb formula Result required
4034 Aspley post code Suburbs
4034 Geebung 4034 Aspley, Geebung, Zillmere
4034 Zilllmere 4035 Beachmere, Cannonhill
4035 Beachmere
4035 Cannonhill
so forth

Document contains list of postcodes & suburbs
Can u please suggest a formula to concatenate the above
Thanks
varun
  #2   Report Post  
varun
 
Posts: n/a
Default

Can anyone please help with this problem..need a formula

thanks

varun

"varun" wrote:

Hello Everyone

An u please suggest a formula to solve this problem

post code Suburb formula Result required
4034 Aspley post code Suburbs
4034 Geebung 4034 Aspley, Geebung, Zillmere
4034 Zilllmere 4035 Beachmere, Cannonhill
4035 Beachmere
4035 Cannonhill
so forth

Document contains list of postcodes & suburbs
Can u please suggest a formula to concatenate the above
Thanks
varun

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
post code on col1 & list of suburbs in col2 - what is the formula varun Excel Discussion (Misc queries) 5 June 2nd 05 05:47 AM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Make Change Case in Excel a format rather than formula Kevin Excel Worksheet Functions 1 March 18th 05 08:53 PM
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 4th 05 10:50 AM
Code Post: Extract Trendline coefficients who Excel Discussion (Misc queries) 2 January 10th 05 11:36 PM


All times are GMT +1. The time now is 02:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"