Duplicate data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paula - 21 Nov 2007 01:47 GMT

my column is long list with much same entries

i want to delte all duplicate entries in column

is easy way?

ty

Reply to this Message

Bernard Liengme - 21 Nov 2007 02:03 GMT

Select all the data
Use Data | Filter | Advance Filter | Unique records only
Copy the visible cell to another part of worksheet (or another worksheet)
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> my column is long list with much same entries
>
[quoted text clipped - 3 lines]
>
> ty

Reply to this Message

Paula - 21 Nov 2007 02:33 GMT

thank you sir

>Select all the data
>Use Data | Filter | Advance Filter | Unique records only
>Copy the visible cell to another part of worksheet (or another worksheet)
>best wishes

Reply to this Message

Evgeny Grischenko - 27 Nov 2007 17:50 GMT

Hello!
In such cases I prefer to use a special add-in for removing duplicate cells
in tables and workbooks:
http://www.office-excel.com/excel-addins/remove-duplicates-excel.html
Maybe it helps you too.
Best regards,
Evgeny

> my column is long list with much same entries
>
[quoted text clipped - 3 lines]
>
> ty

Reply to this Message

Rate this thread: