software

Ho do I remove duplicate rows in excel yet still keep a row but not the
duplicates.--
exceluser2
------------------------------------------------------------------------
exceluser2's Profile: www.excelforum.com/member.php...oamp;userid=31338
View this thread: www.excelforum.com/showthread...hreadid=518048Which column(s) are you comparing to identify duplicates? If A1 = A2, are
rows one and two duplicates? Or A1 amp; B1 = A2 amp; B2? Or A1 amp; B1 amp;C1 = A2 amp; B2 amp;
C2?
Do you have a header row?
--
Ken Hudsonquot;exceluser2quot; wrote:

gt;
gt; Ho do I remove duplicate rows in excel yet still keep a row but not the
gt; duplicates.
gt;
gt;
gt; --
gt; exceluser2
gt; ------------------------------------------------------------------------
gt; exceluser2's Profile: www.excelforum.com/member.php...oamp;userid=31338
gt; View this thread: www.excelforum.com/showthread...hreadid=518048
gt;
gt;


If in a row all cells match another row it would be a duplicate. Even
the header row is duplicated. A1 amp; B1 amp;C1... = A2 amp; B2 amp; C2... 150
cells per row--
exceluser2
------------------------------------------------------------------------
exceluser2's Profile: www.excelforum.com/member.php...oamp;userid=31338
View this thread: www.excelforum.com/showthread...hreadid=518048Checking 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 Hudsonquot;exceluser2quot; wrote:

gt;
gt; If in a row all cells match another row it would be a duplicate. Even
gt; the header row is duplicated. A1 amp; B1 amp;C1... = A2 amp; B2 amp; C2... 150
gt; cells per row
gt;
gt;
gt; --
gt; exceluser2
gt; ------------------------------------------------------------------------
gt; exceluser2's Profile: www.excelforum.com/member.php...oamp;userid=31338
gt; View this thread: www.excelforum.com/showthread...hreadid=518048
gt;
gt;