Question

which filter option is used for most complex criteria?

Answer 1

Explanation:

Excel Advanced Filter with wildcards

Criteria Description

??text Filter cells whose contents begin with any two characters, followed by "text".

text*text Filter cells that begin with "text" AND contain a second occurrence of "text" anywhere in the cell.

="=text*text" Filter cells that begin with AND end with "text".

Answer 2

Answer:

• Multiple criteria, multiple columns, all criteria true
• Insert at least three blank rows above the list range that can be used as a criteria range. ...
• To find rows that meet multiple criteria in multiple columns, type all the criteria in the same row of the criteria range. ...
• Click a cell in the list range.

Explanation:

hope it helps yOu...