You can use following steps of extracting unique  records:

Go to Data
Select Adavanced Filter
Select Copy to another Location
In List Range Select Column A
in Copy to Select G1
Check Unique Record
Press OK

You should have Customer code  in Column A.