| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
