Forum Discussion
I need help with three difference searchable dropdown lists
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
- m_tarlerFeb 05, 2025Bronze Contributor
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.
- sf49ers19238597Feb 06, 2025Iron Contributor
I am sending upadate with bye weeks is empty put team in cell then next cell down try find the same team you pick it should not be on the list anymore. I try to do samething on the NFL schedules files. I getting to work. I try out formula or formulas. Look at NFL schedule first. I want update file NFL schedules same as nfl schedule on bye weeks. The formulas is on Teams infos worksheets for bye weeks and playoffs worksheets.
Thank You
- m_tarlerFeb 06, 2025Bronze Contributor
I don't see any file attached. In the old file I have and attached above those areas still work as you had them. I suspect in the new file the NAME isn't set right. It is looking at a name "NFL_PLAYOFFS_AREA". Check the name manger that it is set correctly: