Forum Discussion

YB_20's avatar
YB_20
Copper Contributor
Apr 26, 2020
Solved

FILTER Formula - Searchable Drop Down Lists

Hi! 

 

I am trying to complete a tutorial on YouTube from Leila Gharani on Searchable drop down lists and am stuck on the filter function so hoping someone might be able to assist me.

 

This filter formula doesn't appear for me so I am struggling to add this section in. Does anyone know how to utilise a dynamic array formula if it doesn't automatically appear like standard formulas?

 

Thank you!! 

 

excel
Formulas and Functions

12 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 26, 2020

    YB_20 

    To my knowledge dynamic arrays are available for Office 365 subscribers only, on all channels except semi-annual, will appear on the latest one this fall.

    • Matthias1885's avatar
      Matthias1885
      Copper Contributor
      May 03, 2020

      SergeiBaklan Hi Sergei, I have Microsoft 365 Personal subscription for Mac and am really interested in using the FILTER function. Should I expect it to be made available in the fall?

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        May 03, 2020

        Matthias1885 

        I don't know which channels are for Mac, you may shift on one with functions available right now. For all channels they shall be available in July-August.

    • YB_20's avatar
      YB_20
      Copper Contributor
      Apr 28, 2020

      Thanks SergeiBaklan!

       

      How would I go about doing this without access to this formula? 

       

      I have two columns of data (name & role) and I am trying to get the role to automatically populate when a name is selected from a searchable drop down list?

       

      Appreciate any assistance!! 

       

      Thank you!!

Resources