Hi,

I'd use Data - Filter - Advanced Filter. Choose 'Copy to another location' &
set a location to copy to. Check the 'Unique records only' box.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"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