Use of Contains in an Advanced Filter

Comments

1 comment

  • Official comment
    Saurabh Agashe

    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 Permalink

Please sign in to leave a comment.