Macro to check against Columns & Delete Duplicates

NoSparks · #1 12-13-2017, 05:59 AM

Updated file for results to eliminate duplicates within column D .

Don't know what the desired output of the results should be.
Looking at this post of almost 2 years ago, I'd say column D isn't actually part of the A:C "table" so probably want what is indicated as Macro Results 2

cjamps · #2 12-13-2017, 06:58 AM

Quote:

Originally Posted by NoSparks

Updated file for results to eliminate duplicates within column D .

Don't know what the desired output of the results should be.
Looking at this post of almost 2 years ago, I'd say column D isn't actually part of the A:C "table" so probably want what is indicated as Macro Results 2

Yes. That is correct.

NoSparks · #3 12-13-2017, 12:32 PM

Quote:

Originally Posted by cjamps

Yes. That is correct.

Is there an improvement in execution speed ?
Can this be considered a solution to what you've requested here or ???

jolivanes · #4 12-13-2017, 02:16 PM

Don't know the layout of your sheet but attached seems to work.
Might be slow on a very large range though.

cjamps · #5 12-13-2017, 09:04 PM

Yes you are right. It does work. I can't understand why it doesn't work on my spreadsheet. I replaced my columns with yours using your spreadsheet, ran the macro and nothing happened. I would post the columns but the phone numbers are confidential.

jolivanes · #6 12-13-2017, 09:21 PM

Any leading or trailing spaces?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA: Delete duplicates in each row	bandaanders	Excel Programming	2	09-02-2015 08:15 AM
Excel vba to check to check if two columns are empty	subspace3	Excel Programming	5	07-09-2015 04:45 PM
Macro to keep first instance and remove duplicates in certain column	zhead	Excel	2	03-18-2015 10:16 AM
find and delete duplicates	rcVBA	Word VBA	4	05-15-2013 03:08 PM
Deleting Duplicates in Macro	jillapass	Excel Programming	1	01-11-2012 10:02 AM