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.
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
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


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

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