Thanks Chip, I think it's exactly what I was looking for ... I will post
back when I'm done with the file.

--Jim

"Dave Peterson" wrote in message
...
: Chip Pearson has some techniques at:
: http://www.cpearson.com/excel/duplicat.htm
:
:
: 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
:
: --
:
: Dave Peterson