Thanks for your post.

I do believe that this will separate the unique records and first occurrences from the duplicate records (If the email address occurs again)

Is it possible to remove all counts of a duplicate including the first occurrence of it. To be left with just the rows where the email addresses that have only occurred once?

Again, thanks for all your help