how to delete rows based on duplicate information in a column

With headers in Row 1, you can use Data|Filter|Advanced filter to show just the
unique entries.

Debra Dalgleish shows how:
http://www.contextures.com/xladvfilter01.html#FilterUR

Do this based on just column A.

Then you can select your range (all columns)
edit|copy
and edit|paste to a new location (a new sheet?)

Only the visible cells should be copied|Pasted.

albertpinto wrote:
>
> Is there a way (beside writing a macro) to delete if you have identical
> entries in a column and you want to keep only one copy of that row. For
> e.g.
>
> A B C
> 1 2 3
> 1 4 5
>
> Since there are Two 1's in A i only want to keep one copy of that row.
>
> Thanks in advace for help,
>
> --
> albertpinto
> ------------------------------------------------------------------------
> albertpinto's Profile: http://www.excelforum.com/member.php...fo&userid=9370
> View this thread: http://www.excelforum.com/showthread...hreadid=546032

--

Dave Peterson

Try this freeware:
http://www.aks-labs.com/support/phpB...topic.php?t=69
This is not Excel plug-in, but works for duplicates finding