E Elliott Board Regular Joined Aug 8, 2005 Messages 73 Nov 12, 2005 #1 Hi, I have an Excel column, 55000 rows, of numbers. I would like to delete all duplicates. Is there a command that will do that? Many Thanks, Elliott
Hi, I have an Excel column, 55000 rows, of numbers. I would like to delete all duplicates. Is there a command that will do that? Many Thanks, Elliott
erik.van.geit MrExcel MVP Joined Feb 1, 2003 Messages 17,832 Nov 12, 2005 #2 Hi, Elliott, take a look at Advanced Filter in the menu Data there is a setting which allows you to filter/copy unique entries kind regards, Erik
Hi, Elliott, take a look at Advanced Filter in the menu Data there is a setting which allows you to filter/copy unique entries kind regards, Erik
E Elliott Board Regular Joined Aug 8, 2005 Messages 73 Nov 12, 2005 #3 Erik, Many thanks, worked liked a champ.
Zack Barresse MrExcel MVP Joined Dec 9, 2003 Messages 10,881 Office Version 3652010 Platform WindowsMobileWeb Nov 12, 2005 #4 Hi there Elliott, Have a look here as well ... http://members.iinet.net.au/~brettdj/ Brettdj's Duplicate Master is a superb add-in which will handle your duplicates in a way that has never been seen in Excel before. It truly is an excellent piece of work.
Hi there Elliott, Have a look here as well ... http://members.iinet.net.au/~brettdj/ Brettdj's Duplicate Master is a superb add-in which will handle your duplicates in a way that has never been seen in Excel before. It truly is an excellent piece of work.