FILTER with wildcards
Excel’s FILTER function sieves a set of data based on defined criteria. However, it doesn’t allow the use of wildcards for partial matches. What are the wildcard characters? * (asterisk) — represents any number of characters. ? (question mark) —…