FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -To use the Advanced Filter to filter with multiple criteria, you need to create a criteria range. In this example, I created the criteria in cells G1 through H2. The top cell in each criteria column must be the same as the headers in the columns you want to filter by.

Detailed explanation-2: -On the Data tab, in the Sort & Filter group, click Advanced. To filter the list range by copying rows that match your criteria to another area of the worksheet, click Copy to another location, click in the Copy to box, and then click the upper-left corner of the area where you want to paste the rows.

Detailed explanation-3: -Advanced Filter allows you to generate a unique list of items and extract those items to another place in your worksheet or workbook. Advanced Filter has several useful features. It allows you to apply several filter criteria simultaneously to the entire data file, which AutoFilter does not.

Detailed explanation-4: -range-defines one or several cells to count. You put the range in a formula like you usually do in Excel, e.g. A1:A20. criteria-defines the condition that tells the function which cells to count. It can be a number, text string, cell reference or expression.