Geek Answers Handbook

How to filter multiple criteria in Excel?

I am trying to filter out a few criteria, but I see that the "Filter" option has only 2 fields for the "AND / OR" options. I have a column full of links. I want to extract all the lines containing them in it:

.pdf .doc .docx .xls .xlsx .rtf .text .csv .pps

Is there a good way to do this?

+5
source share
3 answers

Regular filter options in Excel do not allow you to set more than two criteria. To configure 2+ criteria, you need to use the "Advanced Filter" option. Below are the steps I took to try this.

http://www.bettersolutions.com/excel/EDZ483/QT419412321.htm

. , . . , "OR", "AND".

  • E1:
  • E2: = m
  • E3: = h
  • E4: = j

, 5:

  • A5:
  • A6:
  • A7:
  • ...

(A6) " ". . E1: E4 OK.

. , '='. - .

+4

, , - . .

b14 true , . , . , .

=OR(B14=".pdf",B14=".doc",B14=".docx",B14=".xls",B14=".xlsx",B14=".rtf",B14=".txt",B14=".csv",B14=".pps")

, , , .

+4

AutoFilter xlFilterValues.

PDF, DOC DOCX.

Criteria1:=Array(".pdf", ".doc", ".docx"), Operator:=xlFilterValues
+3

More articles:


All Articles