Forum Discussion
I need help with three difference searchable dropdown lists
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
That is what it does. Note I found a bug where I didn't delete the formulas below the above formula on the INFO sheet. But to make sure I understand what you want here is picture of BYE WEEKS with the WK 7 teams removed showing the drop down options:
and now after adding a few back in:
and because Texans, Jets, and Cowboys were entered the options in the drop down no longer include them. If this isn't what you mean please explain
The file you gave is working but the teams are still on the list when I put teams. I clear put all teams
in three teams weeks
I attachment
I do samething on nfl schedules file. I not getting working I samething on nfl schedule file
Thank You
I'm sorry I don't understand what you are saying.
If you provide an updated file I can work on that. I just don't know what is the problem you are having.