How do I count unique email addresses across multiple worksheets?

[Kenny Brooks]

Hi all,

I'm looking to count unique email addresses across several worksheets. All
email address are in field E in each worksheet. I'm trying to avoid
consolidating all records onto one worksheets. Your help is very appreciated
here!

BTW: Each worksheet represents an event where attendees provided their email
address - some users attended multiple events. I'm trying to get an overall
unique count of attendees.

 

[M Kan]

Not sure how to do that across mutiple worksheets, but you could consolidate
just the email addresses from each sheet into a separate workbook, then run a
pivot table on the address, which would give you a list of uniques, and a
count of how many functions were associated with each.

Copy and paste as values the result list of addresses

 

[Kenny Brooks]

Thanks M Kan for responding.

I'm constantly adding new worksheets and would prefer not to have to
constantly update email addresses on a new worksheet every time I add a new
worksheet (I use other formulas that sum up data from all these worksheets on
one summary worksheet). If I can create a formula that accomplishes my
objective (below) then all I have to do is make a minor tweak to it when I
add a worksheet.

My thanks to anyone who helps!
- Kenny