Chip Pearson has various "Duplicate" formulas at his website.

http://www.cpearson.com/excel/duplic...gingDuplicates


Gord Dibben MS Excel MVP

On Fri, 13 Jan 2006 11:37:20 -0500, "Spike9458" wrote:

I have a list of about 6000 line items. Among other things, the data
includes names and email addresses. There are many duplicate entries,
checking line by line for 6000 lines is not very appealing to me.

Can someone help me to devise a formula or other way to do this?

Thanks,

--Jim