Hi.
I recently upgraded to Office 365 and am trying to take advantage of the new FILTER function to have a searchable drop-down list.
I am attaching a sample of how I am trying to use it. I was able to get it to work on the first row of the Measurement & Ingredient fields on the Recipe Entry sheet.
Is there a way to get this to work on all of the rows without having a separate spill list for each field?
My actual spreadsheet has room for 100 recipes. I would rather not have to create 2500 spill lists to make this work. Any suggestions?
TIA!
Bookmarks