Getting rid of matching records?

H

HotRod

Instead of trying to do this in VBA I have a large excel file with 50'000 +
duplicate postal codes. What I'd like to do is when ever a postal code is in
the file more than once I'd like to delete all of instances of that postal
code.

e.g.
N0N1J0
N0M1K6
N8Y7J4
N0N1J0

RESULT (remove N0N1J0)
N0M1K6
N8Y7J4
 
H

HotRod

THANKS
I ended up using this and it worked great.

IF((AND(A2<>A3,A2<>A1)),"","DELETE")
 
Top