Excel function formula filter

Originally Posted by Richard Buttrey

No,
As I understand it it's only availabe in Office 365 and is currently a beta version for a limited subset of testers
See this Microsoft article https://support.office.com/en-us/art...c-4877ad80c759


You'll need to use an Advanced Data Filter.
That can of course be done manually or with a simple macro like

Please Login or Register  to view this content.

Where "Data" is your data range, "DataOut" is a single row of column labels taken from the Data range, and "Crit" is a criteria range consisting of a column label and underneath the value you're filtering for.
Change the VBA Sheet code names as necessary.

Thanks but I was hoping to use FILTER function together with other formula so that I can create a drop down list filtered results based on keyword search.

we have over 9000 project ids and users usually only remember some letters of the project id or certain codes of the project id. I was hoping to use a suggested way in youtube video:

=FILTER(Data, ISNUMBER(SEARCH(CELL,data)),"not found")

Data is the array data and CELL is where the user will input parts of keyword.