Macro to check against Columns & Delete Duplicates

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Macro to check against Columns & Delete Duplicates

FAQ

Thread Tools

Display Modes

#22

12-15-2017, 10:49 AM

NoSparks

Windows 7 64bit Macro to check against Columns & Delete Duplicates

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

The array macro leaves only these of column D
and only one of each

999-999-5977
999-999-3367
999-999-0575
999-999-9429
999-999-2672
999-999-6295

is this correct ?

Attached Files

cjamps_posted_data.xlsm (60.4 KB, 11 views)

Last edited by NoSparks; 12-15-2017 at 04:25 PM. Reason: included file

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:45 AM.