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.

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.

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

"M Kan" wrote:

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.