Duplicates

[Jason Marino]

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?

 

[Traveller]

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.

 

[nboow]

You could use Data>Filter>Advanced Filter to filter for unique items only.. http://www.contextures.on.ca/xladvfilter01.html#FilterUROr you could highlight/flag the duplicates and remove.http://www.cpearson.com/excel/Duplicates.aspxGord Dibben MS Excel MVPOn Wed, 17 Oct 2007 14:50:11 -0400, Jason Marino <[email protected]> wrote:>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?

How do you flag an entry in a cell on a worksheet that is a duplicate entryin a cell on a previous worksheet?