P Paula Nov 21, 2007 #1 my column is long list with much same entries i want to delte all duplicate entries in column is easy way? ty
my column is long list with much same entries i want to delte all duplicate entries in column is easy way? ty
B Bernard Liengme Nov 21, 2007 #2 Select all the data Use Data | Filter | Advance Filter | Unique records only Copy the visible cell to another part of worksheet (or another worksheet) best wishes
Select all the data Use Data | Filter | Advance Filter | Unique records only Copy the visible cell to another part of worksheet (or another worksheet) best wishes
E Evgeny Grischenko Nov 27, 2007 #4 Hello! In such cases I prefer to use a special add-in for removing duplicate cells in tables and workbooks: http://www.office-excel.com/excel-addins/remove-duplicates-excel.html Maybe it helps you too. Best regards, Evgeny
Hello! In such cases I prefer to use a special add-in for removing duplicate cells in tables and workbooks: http://www.office-excel.com/excel-addins/remove-duplicates-excel.html Maybe it helps you too. Best regards, Evgeny
