blahmin027
New Member
- Joined
- Jun 9, 2014
- Messages
- 32
I have a list of attendees, and I want to know if the person is a new attendee (meaning never attended any of the webinars since Jan) or is a returning attendee. For example:
I am not counting uniques (David, Mary, Pat, Sam, Mat) but I want to know how many have appeared on my list only once (Pat, Sam).
I am stumped and don't know what formula I should use. Any help will be appreciated
David | Webinar 1 |
Mary | Webinar 2 |
David | Webinar 2 |
Pat | Webinar 1 |
Sam | Webinar 2 |
Mary | Webinar 3 |
Mat | Webinar 1 |
Mat | Webinar 2 |
I am not counting uniques (David, Mary, Pat, Sam, Mat) but I want to know how many have appeared on my list only once (Pat, Sam).
I am stumped and don't know what formula I should use. Any help will be appreciated