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

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

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

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