Hi Woolstar,

It's not clear what you want.

To exclude email addresses from the test, change the first formula to:
=A2&B2&C2&E2
To inc;ude the 'initial' occurences of duplicates amongst the duplicates, , change the second formula to:
=COUNTIF(F:F,F2)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]