View Single Post
  #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