Is there a way to filter using contain. I need to change the following code to pull up anything that has the array below in it. For instance: "QA Approval (Amended) Offer 3"" should pull up.
Please Login or Register to view this content.
Is there a way to filter using contain. I need to change the following code to pull up anything that has the array below in it. For instance: "QA Approval (Amended) Offer 3"" should pull up.
Please Login or Register to view this content.
You can use an array with filter with many criteria, but if you want to include asterisk * for partial match, it works with 2 criteria ONLY
You could put a compilation of what you're looking for into a single named list, then use a set of formulas to filter instead of the values, using the formula:where "A1" is the value in the column you would have been filtering and "mylist" is the name of the list of things you want to find contained in the values in column A, then filter the column of these formulas for TRUE.Formula:Please Login or Register to view this content.
If I helped, please click on Add Reputation.
Both solutions are great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks