Use of Contains in an Advanced Filter
Is there a way to construct an Advanced Filter using a contains function? I'd like to filter based on a substring being contained with a string value. I tried the obvious syntaxes, but everything I tried resulted in an error. On a Basic Filter I can choose the Contains option, but what's the syntax for using that in an Advanced Filter?
-
Official comment
The advance filter option gives you full access to all the available functions in the workbook. A good way to use the advance filter when starting out is to create the filter you are trying to use on a column of the sheet you are attempting to filter. Remember since this is the condition, make sure that result of the column is a boolean. This also serves as a good spot check to see if you are getting the results you are looking for. Then once satisfied, you can copy the formula in the "filter" column into the advance filter and remove the "filter" column.
An alternative is to keep the "filter" column and run a basic filter on that column for TRUE values
Comment actions
Please sign in to leave a comment.
Comments
1 comment