Getting rid of matching records?

  • Thread starter Thread starter HotRod
  • Start date Start date
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
 
THANKS
I ended up using this and it worked great.

IF((AND(A2<>A3,A2<>A1)),"","DELETE")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get the counting of something to get unique info 8
for every cell search identical in range, not whole column; how? 2
Importing a text file 3
Lookup Function Not in Ascending Order 14
Import specific columns from Excel 1
Importing an Excel Database 1
remove duplicates 1
Importing spreadsheet with matching name fields 1

Back
Top