Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-17-2017, 10:05 AM
NoSparks NoSparks is offline deleting blanks and commas Windows 7 64bit deleting blanks and commas 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

Well.... this "final" request requires some clarification.

What determines a record to be a duplicate? Every cell of the row being the same, or just certain columns?
Do you or are you able to sort the data so the duplicates are together?
Which of the duplicates should be moved to the dupesheet?
How, when, why would you know this macro should run?

And after that, what's causing the duplicates and can they be prevented?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot not showing number format with commas olybobo Excel 1 05-05-2016 05:09 PM
deleting blanks and commas Counting Blanks in 1 Column and Non-Blanks in Another dogwood705 Excel 4 02-07-2015 08:45 AM
Commas within fields in .csv files gar Excel 1 01-29-2015 09:24 PM
deleting blanks and commas How to use mid or left functions to seperate city,st,zip with no commas sinaranje Excel 4 11-11-2014 10:52 PM
deleting blanks and commas No inverted commas in word 2013. tonycrossley Word 3 01-27-2014 04:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:03 AM.


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