I have 3 worksheets (Sheet 1, Sheet 2, Sheet 3) which contain email addresses in column J.

Each worksheet has a separate group/bucket of data however some of the email addresses in each sheet may be the same

I am looking for a formula to count only unique values (emails) from Sheet 1 column J which are not in Sheet 2 column J and are not in Sheet 3 column J.

For example, if johndoe@ is in Sheet 1 column J multiple times as well as in Sheet 2 and Sheet 3 column J multiple times. I would like to receive a count of 1.

Any suggestions would be highly appreciated.

Thanks in advance!