Hello,
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!
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!