Duplicates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jason Marino - 17 Oct 2007 19:50 GMT

I have a quick excel question - do you know how to clean up duplicate
entries in an excel spreadsheet - is there a function available on excel to
do this?

Reply to this Message

Gord Dibben - 17 Oct 2007 19:55 GMT

You could use Data>Filter>Advanced Filter to filter for unique items only.

http://www.contextures.on.ca/xladvfilter01.html#FilterUR

Or you could highlight/flag the duplicates and remove.

http://www.cpearson.com/excel/Duplicates.aspx

Gord Dibben MS Excel MVP

>I have a quick excel question - do you know how to clean up duplicate
>entries in an excel spreadsheet - is there a function available on excel to
>do this?

Reply to this Message

Traveller - 18 Oct 2007 01:53 GMT

You could also go to ASAP.com for the free ASAP add-in which, among many
other utilities, has a quick, convenient way to highlight duplicates.

> I have a quick excel question - do you know how to clean up duplicate
> entries in an excel spreadsheet - is there a function available on excel to
> do this?

Reply to this Message

Rate this thread: