Forum Discussion
I need help with three difference searchable dropdown lists
I need help with three searchable dropdown lists on a team info worksheet. I want to make the work searchable with no repetition. The list goes on the worksheets. When a team is picked, the team will...
in attached file the 'BYE WEEKS' tab already has Data Validation (drop downs) set to the 'TEAMS REMAINING' column on the 'TEAMS_INFOS' tab (D37). I updated the formula in cell D37 to be
=FILTER(TEAMS_NAMES,NOT(ISNUMBER(XMATCH(TEAMS_NAMES,TOCOL('BYE WEEKS'!B3:Q25)))),"")this formula will dynamically update that list to be only the teams not picked yet.
Delete names on the BYE WEEKS tab and you will see.
NOTE: If you try to attach a file for us it appears you can NOT attach a .XLSB file type. I may be possible to save as a macro-enabled file (.xlsm) but better yet, especially if you aren't asking for help with a macro, please save as .XLSX
I like it but I want when pick it will not show on the list again