Hi, I believe it can be done by first sorting by surname, then "if" formulae
to check if the same e-mail address is existing just after that. Finally u
can re-sort by surname. It works, Please do write if need more clarification.
thanks
amit.

"The Fool on the Hill" wrote:

Dear Excel(lent) users,

I have a problem with checking for double entries.

I have a sheet with name, surname, email address and contact person.

I want to check if there are double entries on email address. The problem is
that I need to sort on Surname. Can I do something with conditional
formatting or any other suggestions?

PLease help !

Thank you very much for your time and support !

Kind regards,

Jay