The following formula will not work and for the life of me I can not
figure out why:
=if(isna(match($a2,$e$2:$m$7,0)),$a2," ")
In cell a1 is the text "All Players". From cells a2-a55, I have the
following data: player1, player2, player3...player54. In cell b1 is
the text "Available players". From cells b2-b55, I have the above
formula so the default values are the same values as column a. From
cells d2-d7 is the text team 1, team 2...team 6. The values in cell
range e2:m7 will be populated by a dropdown box which includes all the
data from cells a2:a55. When I pick a name from the dropdown box in
any cell in the e2:m7 range, the corresponding value in column b
should be removed and replaced by a blank space. At least that is how
I think the above formula should work but it doesn't do anything. Can
someone help me with this? Thanks.