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
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips
"Kenny Brooks" wrote:
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.