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