so I’ve got 2 Tables.
Table 1 is my Main sheet, Table 2 has data that i’m pulling into Table 1 via Dereference.
Once I make my selection in Table 1, is it possible to make that option disappear to avoid selecting it twice and make it easier to choose from as only the not-used options are available?
hope this make sense.
thanks!!!
Yes, It is possible
In the dropdown column, use valid formula - Select(Table2[Column with options], True) - Select(Table1[Column with dropdown], True)
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |