babsc01
07-28-2004, 08:48 AM
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!!!
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!!!