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
I have tried a few different ways but cannot see a way round it.
I thought about using IF, IFERROR, VLOOKUP, INDEX and MATCH.
Any ideas?
Bookmarks