I have a list of names, that have duplicates of the same name. How do I filter out the duplicates?
S Stephanie Myers Oct 4, 2004 #1 I have a list of names, that have duplicates of the same name. How do I filter out the duplicates?
N Niek Otten Oct 4, 2004 #2 Hi Stephanie, http://www.cpearson.com/excel/deleting.htm -- Kind Regards, Niek Otten Microsoft MVP - Excel
Hi Stephanie, http://www.cpearson.com/excel/deleting.htm -- Kind Regards, Niek Otten Microsoft MVP - Excel
S Stephanie Myers Oct 4, 2004 #3 Thanks, but I don't understand where or how I type in the specific coding. Can you help me get to the menu or place where I would type in the code? Thanks much!
Thanks, but I don't understand where or how I type in the specific coding. Can you help me get to the menu or place where I would type in the code? Thanks much!
F Frank Kabel Oct 4, 2004 #4 Hi use 'Data - Advanced Filter' and check 'Unique entries'. Or use Ron's addin for this: http://www.rondebruin.nl/easyfilter.htm
Hi use 'Data - Advanced Filter' and check 'Unique entries'. Or use Ron's addin for this: http://www.rondebruin.nl/easyfilter.htm