View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ken Hudson
 
Posts: n/a
Default 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