• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to get excel search results list

ThemExcel
As a new member,
You have just read Forum Rules
and from How to get the Best Results at Chandoo.org
You have gotten good hints
what to write ...
Should You reread those Forum Rules and
after that, do as there has been written to get the Best Results at Chandoo.org ?
 
With no further information,
= FILTER(Table1, ISNUMBER(SEARCH(Criterion, Table1[Column1])))
might provide an answer.

I have chosen to assume you use Microsoft 365 and the records you wish to filter are held as an Excel Table.
 
Back
Top