Wildcard characters are useful when we have partial search criteria to extract or manipulate data. In Excel, we use "?" and "*" are wildcard characters. "?" represents single character, and "*" represents series of characters.
Wildcard characters are used with Excel functions, such as VLOOKUP, SUM, COUNT, SUMIF, COUNTIF and SUBSTITUTE among others. In the below Table, we have sales details of computer hardware items sold with their selling price and no. of items sold.
Product List:
We also have some scenario or conditions to extract data from the table to get desired output. Below is a picture of combination of Excel formulas and wildcard characters to get the desired result.
Scenario with Formula:
0 comments:
Post a Comment