H Hunt Dec 2, 2008 #1 Is it possible to filter or sort a spreadsheet (Excel 2007) and automatically eliminate duplicate entries?
Is it possible to filter or sort a spreadsheet (Excel 2007) and automatically eliminate duplicate entries?
P Per Jessen Dec 2, 2008 #2 Hello Use an advanced filter, and select "Unique records only". Hopes it helps. Regards, Per
A Ashish Mathur Dec 3, 2008 #3 Hi, In Excel 2007, there is also an option to Remove duplicates (Data > Data Tools) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com
Hi, In Excel 2007, there is also an option to Remove duplicates (Data > Data Tools) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com
