LinkBack URL
About LinkBacks
GMBunk 
Hi have an excel column that has 18,000 entries. I know it's possible to highlight duplicates or indicate which values are "duplicates".. is it possible to have the duplicates removed?
Hi have an excel column that has 18,000 entries. I know it's possible to highlight duplicates or indicate which values are "duplicates".. is it possible to have the duplicates removed?
Take a look at this link
http://www.cpearson.com/excel/duplicat.htm
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Thanks.. my issue is the column that we are removing duplicates from is based on a formula that pulls from another column. Please advise.Originally Posted by oldchippy
Presumably, if you remove one of the duplicates, you still have the other with the same formula still intact. Open up the Auditing Toolbar and see if by retaining one duplicate it still doesn't mess things up?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks