TerrorTot38
New Member
- Joined
- Feb 2, 2022
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
I am trying to extract / filter a list of names based on if a player is attending. For example if Player A is FALSE(not playing) only show the last 3 pairs highlighted in the example below.
I have a list of names of players. Column A (Players) Column B (Attending T / F)
- Player A - FALSE
- Player B - TRUE
- Player C - TRUE
- Player D - TRUE
I then have a list of pairs for example. Column D (Pairs not played)
- Player A & Player B
- Player A & Player C
- Player A & Player D
- Player B & Player C
- Player B & Player D
- Player C & Player D
Thus far I have
For example Kim and Kimberley are 2 different values.
Any ideas?
I have a list of names of players. Column A (Players) Column B (Attending T / F)
- Player A - FALSE
- Player B - TRUE
- Player C - TRUE
- Player D - TRUE
I then have a list of pairs for example. Column D (Pairs not played)
- Player A & Player B
- Player A & Player C
- Player A & Player D
- Player B & Player C
- Player B & Player D
- Player C & Player D
Thus far I have
Excel Formula:
=VLOOKUP("*"&J2&"*",$M$2:$M$104,1,FALSE)
For example Kim and Kimberley are 2 different values.
Any ideas?