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