Hello. I have a spreadsheet that I need to count duplicate attendees but at different shows. Column A has the name of the show. column D has the full name of the person attending the show and column E has the company name the person works for. I need a formula that tells me if someone in column D attended 2 different shows. For example. If John Doe from Company X is listed twice in column D but Column A says he went to show A and show B. Is this possible? Thanks.