Link to home
Start Free TrialLog in
Avatar of gregfthompson
gregfthompsonFlag for Australia

asked on

File contains a list of multiple postcodes and names

File contains list of postcodes and suburb names where the same postcode number is often repeated with a different suburb name. The task is to extract the first postcode with corresponding suburb name and ignore subsequent same postcodes.
The result is to be a list of postcodes with no repeated postcodes. File is attached showing existing list in columns A&B and example of required list in columns D&E.
Postcode-Australia-Delivery-Area.xlsx
ASKER CERTIFIED SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gregfthompson

ASKER

Thank you!!
PS What's the process to remove the alternating colours for each row?

Thanks.
Thank you!!!
You're welcome.. glad that was all you needed.