Ok. I have three columns of text I'm dealing with here. The first column is a
the "Athletes Name" column, which represents the athletes name, the second
column is "M or F" which represents Male or Female, and the last column is
"Team Name", which represents the team each person is play on. I have to give
an analysis based on how many all male teams, female teams and co-ed teams we
currently have competing based on the information provided. Is there a
function on excel that can pull the teams that only have male athletes,
female athletes and teams comprising both male and female athletes? I hope
this isn't too confusing. Please help...thanks.