Excel Magic Trick 525: Advanced Filter With Wild Cards




About this tutorial:

Video duration: 2:15
See how to extract records using Advanced Filter and criteria that uses Wild Cards. See how to extract records that start with the letter W or J.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

1 thought on “Excel Magic Trick 525: Advanced Filter With Wild Cards

    ExcelIsFun

    (January 12, 2018 - 2:03 am)

    I only know of two wild cards:

    * = 1 or more characters
    ? = 1 character

    That is why:

    =COUNTIF(A1:B12,"?*")

    Counts the number of text entries, at least one or more text characters.

Leave a Reply

Your email address will not be published. Required fields are marked *