Excel Magic Trick 525: Advanced Filter With Wild Cards

1
19




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.

1 COMMENT

  1. 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

Please enter your comment!
Please enter your name here