Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing duplicate rows
Ho do I remove duplicate rows in excel yet still keep a row but not the duplicates. -- exceluser2 ------------------------------------------------------------------------ exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338 View this thread: http://www.excelforum.com/showthread...hreadid=518048 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing duplicate rows
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. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "exceluser2" wrote: Ho do I remove duplicate rows in excel yet still keep a row but not the duplicates. -- exceluser2 ------------------------------------------------------------------------ exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338 View this thread: http://www.excelforum.com/showthread...hreadid=518048 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking for duplicate records / rows | Excel Discussion (Misc queries) | |||
Removing duplicate entries. | Excel Discussion (Misc queries) | |||
Removing rows that don't show the lowest stock each day | Excel Discussion (Misc queries) | |||
Find duplicate rows and add together | Excel Discussion (Misc queries) | |||
Showing Duplicate rows in excel | Excel Discussion (Misc queries) |