Forum Discussion
Excel on Mac - 16.38 - Drop Down doesn't trigger sheet calculation/formula
Looking for assistance. Just updated to 365 16.38 from 2011 on a Mac. I have multiple drop down boxes on a sheet that rely on formulas to allow them to search for characters typed inside them and r...
Jeff_Sturgeon do you have the new array functions available?? I see that the functions are calling some of those new functions and if they aren't enabled in your version of Excel then it won't work. Simply click on the "Pet Feed" cell (C5) and if the formula starts with something like _xlfn._xlws then it won't work for you. Don't worry, this functionality is still getting rolled out and will get to you soon (and hopefully to me too
NVM - I just saw your video and that isn't the problem
🙂
Nope. Nothing like that.
=FILTER(MasterData!B2:B32,MasterData!A2:A32=Report!B5,"")
This is what populates the formula bar.
