I have a table with two sheets. The first (Records) records the players from the form and a filter is performed here to determine the team (1 or 2 or 3) also.
The second table (Players) will perform calculations for individual players (one row for one player). In the first column, I will select a player using a dropdown. The problem is that all players are in the dropdown. I need the filtered ones (eg team 1 and 3). Can anyone help me? Thanks
=FILTER(Records!D2:D; Records!F2:F=1)