Filter Formula

[gheyman]

I am watching a YouTube video and its using =Filter to create a Searchable drop down list. But when I try to recreate whats on YouTube It doesn't like "=Filter" the only option is Filterxml which I think is completely different.

'=Filter(A:A,Isnumber(search(D1,A:A))"not found")

 

[Fluff]

That's one of the new dynamic array functions, which I think are only available through the Insiders program

 

[gheyman]

Thanks, but I am not sure how to interpret that. does that mean its not possible to use the "Filter" formula anymore?

 

[Fluff]

Are you running office 365?

 

[gheyman]

Office 2016

 

[Fluff]

In that case you don't have access to the new dynamic array functions, such as Filter.