ExcelBanter - Post code & Suburbs

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Post code & Suburbs (https://www.excelbanter.com/excel-discussion-misc-queries/28712-post-code-suburbs.html)

varun

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

varun

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

All times are GMT +1. The time now is 12:13 AM.