Differentiate between Criteria Range and Copy to options in the Advance Filter dialogue box. Briefly describe it in your own words.
Answers
Answer:
in the criteria range for an Excel advanced filter, you can set the rules for the data that should remain visible after the filter is applied. You can use one criterion, or several. WARNING: When you use text criteria, Excel interprets it as "begins with". If you need an exact match, see the Exact Match example below.
You can use the Advanced Filter to create more powerful filters, such as filtering for unique records and using operators such as OR. Tea is in the Product name column twice. To filter so that tea displays only once, on the DATA tab, click Advanced. In the Advanced Filter dialog box, click the List range.
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.