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
>
>