View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kenny Brooks Kenny Brooks is offline
external usenet poster
 
Posts: 1
Default How do I count unique email addresses across multiple worksheets?

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.