To filter multiple keywords in Excel at the same time, you can use multiple filter criteria.First, when you select a data range to filter, make sure that the data in the range has been formatted to an appropriate numeric type (such as date, number, etc.).Then, enter the first keyword in the filter dialog box and select the appropriate condition type (such as number, text, etc.).Next, repeat the process, input a keyword each time, and select the corresponding condition type until all keywords are added. In addition, when using multiple keywords for filtering, you can also consider using logical operators such as "and", "or" to combine keywords.This will allow you to filter data based on multiple conditions, rather than relying on a specific condition. To sum up, to filter multiple keywords in Excel at the same time, you need to use multiple filter conditions, and use appropriate logical operators to combine these conditions as needed.In this way, you can quickly and accurately filter out the data range that meets the requirements.
Assume that the source data is in Column A and entered in B1 =IF (ISERR (FIND ("keyword", A1)), A1, "") Enter and fill down. "Keyword" - "" is changed to the string you want to query.
It will be easier to use an auxiliary column. Assuming the column to be filtered is in column c, right-click column d, insert, and enter in the new d1 =Countif (c1, "* Chinese *")+countif (c1, "* Chinese language and literature *")+countif (c1, "* unlimited *") 0 Copy the formula (select d1 again, double-click the "+" in the lower right corner) Click column d, data, and auto filter. Click the d1 drop-down box and select true.
You can only use the function formula, assuming that your data is A2~A5, B2~B5, D2~D5 in sheet1, a1 selects "Guangdong", b1 selects "Zhaoqing", c1 selects Foshan;Enter=INDEX (sheet1! A $2: A $5, SMALL (IF ((sheet1! $A $2: $A $5="Foshan") * (sheet1! $B $2: $B $5="Guangdong") * (sheet1! $C $2: $C $5 - "Zhaoqing" 0)=1, ROW (A $1:.Another way is to draw two tables, one for data, one for screening conditions, and use advanced screening.The data is written to the list area, and the condition is written to the condition area, then OK.See more answers