Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Macro to check against Columns & Delete Duplicates Macro to check against Columns & Delete Duplicates
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 12-13-2017, 05:59 AM
NoSparks NoSparks is offline Macro to check against Columns & Delete Duplicates 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
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
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
Attached Files
File Type: xlsm cjamps_MSOForum_v2.xlsm (24.2 KB, 11 views)
Reply With Quote
  #2  
Old 12-13-2017, 06:58 AM
cjamps cjamps is offline Macro to check against Columns & Delete Duplicates Windows 8 Macro to check against Columns & Delete Duplicates Office 2010 32bit
Novice
Macro to check against Columns & Delete Duplicates 		 
Join Date: Mar 2017
Posts: 16
cjamps is on a distinguished road
Default
Quote:
Originally Posted by NoSparks View Post
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.
Reply With Quote
  #3  
Old 12-13-2017, 12:32 PM
NoSparks NoSparks is offline Macro to check against Columns & Delete Duplicates 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
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
Quote:
Originally Posted by cjamps View Post
Yes. That is correct.
Is there an improvement in execution speed ?
Can this be considered a solution to what you've requested here or ???
Reply With Quote
  #4  
Old 12-13-2017, 02:16 PM
jolivanes jolivanes is offline Macro to check against Columns & Delete Duplicates Windows 10 Macro to check against Columns & Delete Duplicates Office 2013
Advanced Beginner
  
Join Date: Sep 2011
Posts: 91
jolivanes will become famous soon enough
Default
Don't know the layout of your sheet but attached seems to work.
Might be slow on a very large range though.
Attached Files
File Type: xlsm cjamps.xlsm (18.2 KB, 10 views)
Reply With Quote
  #5  
Old 12-13-2017, 09:04 PM
cjamps cjamps is offline Macro to check against Columns & Delete Duplicates Windows 8 Macro to check against Columns & Delete Duplicates Office 2010 32bit
Novice
Macro to check against Columns & Delete Duplicates 		 
Join Date: Mar 2017
Posts: 16
cjamps is on a distinguished road
Default
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.
Reply With Quote
  #6  
Old 12-13-2017, 09:21 PM
jolivanes jolivanes is offline Macro to check against Columns & Delete Duplicates Windows 10 Macro to check against Columns & Delete Duplicates Office 2013
Advanced Beginner
  
Join Date: Sep 2011
Posts: 91
jolivanes will become famous soon enough
Default
Any leading or trailing spaces?
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to check against Columns & Delete Duplicates VBA: Delete duplicates in each row bandaanders Excel Programming 2 09-02-2015 08:15 AM
Macro to check against Columns & Delete Duplicates 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
Macro to check against Columns & Delete Duplicates find and delete duplicates rcVBA Word VBA 4 05-15-2013 03:08 PM
Macro to check against Columns & Delete Duplicates 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 12:58 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft