Hello...been trying to figure this one out lately. How can I identify unique members of a range by the contents of another range? Look at the attached example.

Suppose I want to identify those players that play in a combination of certain sports, and label them based on those combinations. Such as:

IF SPORT = "Baseball" + "Football" then PLAYER = "Major League"
IF SPORT = "Lacrosse" then PLAYER = "Net"
IF SPORT = "Football" and NOT "Lacrosse" then PLAYER = "Strong"

Something along those lines...I know it's a very crude example.

I could accomplish this with a Pivot Table, but I'm trying to write some code and/or formulas that will (1) uniquely identify each PLAYER, and (B) label the player based on a combination of sports.

Any ideas? THANKS!!!