| 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
Which column(s) are you comparing to identify duplicates? If A1 = A2, are
rows one and two duplicates? Or A1 & B1 = A2 & B2? Or A1 & B1 &C1 = A2 & B2 & C2? Do you have a header row? -- Ken Hudson "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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing duplicate rows
If in a row all cells match another row it would be a duplicate. Even the header row is duplicated. A1 & B1 &C1... = A2 & B2 & C2... 150 cells per row -- exceluser2 ------------------------------------------------------------------------ exceluser2's Profile: http://www.excelforum.com/member.php...o&userid=31338 View this thread: http://www.excelforum.com/showthread...hreadid=518048 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
removing duplicate rows
Checking for an entire duplicate row is beyond my ability.
If we can check the first several columns in one row against several columns in another row, we can easily delete duplicates. Might this work? -- Ken Hudson "exceluser2" wrote: If in a row all cells match another row it would be a duplicate. Even the header row is duplicated. A1 & B1 &C1... = A2 & B2 & C2... 150 cells per row -- 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 | |||
| Removing duplicate entries. | Excel Discussion (Misc queries) | |||
| Is there a simple way of removing duplicate data in Excel? | Excel Worksheet Functions | |||
| 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) | |||
Hybrid Mode
