Count Unique Attendees For Each Event with COUNTUNIQUEIFS
Learn how to count unique attendees for each event using the COUNTUNIQUEIFS function in Google Sheets, ensuring accurate attendance tracking even with duplicate entries.
We have four attendees for round one, but Avery was counted twice. If you have a list of attendees and you don't necessarily know if they're correctly attributed. You have this opening ceremonies, Bob, and down here, Bob as well. You want to find how many attendees per each event. Count unique , right? But we're going to get just six for everyone, but we want it for each event. How do we find just the unique attendees for opening ceremonies? Use count, unique , ifs, select our range , the thing that we want to count. And criteria range . Event in this case, B6 colon B. Hit another comma, and we're going to have the criterion. We can put in, Opening Ceremonies, or we can select B1. Now we have three. But this B1, we have to retype here. What we can do instead is right click. Count Unique Attendees For Each Event Find Duplicates in Other Column
Drop down. Over here on the right, drop down from a range . Do B6 colon B. It'll automatically get all of the unique items here. Now we can select from a drop down range , and we can get the unique attendees for each one. Count Unique Attendees For Each Event Searchable Dropdown