sarahw2271
New member
- Joined
- Aug 20, 2014
- Messages
- 8
- Reaction score
- 0
- Points
- 0
I have a spreadsheet containing the names and email addresses of everyone who has ever bought a ticket to one of our events (5 years worth of concerts). I want to know if there is a way to calculate how many people who bought tickets to a show also bought tickets to each of the other shows. I am trying to determine which concerts have the most overlap in audience. Are there any tricks in excel for doing this? (column A= event name, column B= user's email address)