Forum Discussion
Excel on Mac - 16.38 - Drop Down doesn't trigger sheet calculation/formula
mathetes What I believe Jeff_Sturgeon is having a problem with is that as he types in the cell a partial name and then clicks the down arrow it isn't filtering to that partial entry and only filters AFTER he hits enter. I don't know of any functionality that would do that. I think you have to ENTER the data in the cell 1st and then the filter will get applied. I would be curious to see this youtube.
What's interesting here is that I actually had downloaded a week or two ago that very same sample worksheet. If you go to YouTube and search for Leila's name (plus Excel, perhaps) you should find it.
In my using the spreadsheet--the one I downloaded as well as the one Jeff posted--I notice the same phenomenon. The filtering isn't as "live" as I would have expected it to be. It works, but only "kinda works"..
I too, like Jeff_Sturgeon , am on a Mac, so maybe that is a factor.
So I'm attaching a spreadsheet of my own creation, one intended to illustrate how a secondary data validation cell can be created based on what's entered in the first....all using the most recent Dynamic Array functions. There's a table of first and last names that can be extended to your heart's content, and you'll see how both the primary and the secondary entry screens have their lists of acceptable answers grow. I don't know if this is a solution for you, Jeff_Sturgeon , but take a look.