Ho do I remove duplicate rows in excel yet still keep a row but not the duplicates.
E exceluser2 Mar 1, 2006 #1 Ho do I remove duplicate rows in excel yet still keep a row but not the duplicates.
C Chris Marlow Mar 2, 2006 #2 Hi, I'd use Data - Filter - Advanced Filter. Choose 'Copy to another location' & set a location to copy to. Check the 'Unique records only' box. Regards, Chris.
Hi, I'd use Data - Filter - Advanced Filter. Choose 'Copy to another location' & set a location to copy to. Check the 'Unique records only' box. Regards, Chris.
