1. To prepare a filtered list at a new place, choose the
Advanced Filter dialog box.
option in the
2. Excel can sort data in more than one fields using the
Sort dialog box.
option of the
3.
make the comparison of data easy at different points.
then
4. Excel first sorts
blank cells.
followed by
5. The
filter is used to add more than are criterion.
Answers
Explanation:
But First… What is Excel Advanced Filter?
Excel Advanced Filter – as the name suggests – is the advanced version of the regular filter. You can use this when you need to use more complex criteria to filter your data set.Using Criteria in Excel Advanced Filter
Getting unique records is one of the many things you can do with Excel advanced filter.
Its primary utility lies in its ability to allow using complex criteria for filtering data.
Here is what I mean by complex criteria. Suppose you have a dataset as shown below and you want to quickly get all the records where the sales are greater than 5000 and the region is the US.
Here is how you can use Excel Advanced Filter to filter the records based on the specified criteria:
The first step when using Excel Advanced Filter with complex criteria is to specify the criteria. To do this, copy the headers and paste it somewhere in the worksheet.
Excel Advanced Filter - criteria copy
Specify the criteria for which you want to filter the data. In this example, since we want to get all the records for the US with sales more than 5000, enter ‘US’ in the cell below Region and >5000 in the cell below Sales. This would now be used as an input in Advanced Filter to get the filtered data (as shown in the next steps).
Excel Advanced Filter - criteira Specify
Select the entire data set (including the headers).
Go Data tab –> Sort & Filter –> Advanced. This will open the Advanced Filter dialog box.
Excel Advanced Filter - Data Tab
In the Advanced Filter dialog box, use the following details:
Action: Select the ‘Copy to another location’ option. This will allow you to specify the location where you can get the list of unique records.
List Range: Make sure it refers to the dataset from which you want to find unique records. Also, make sure headers in the data set are included.
Criteria Range: Specify the criteria we constructed in the steps above. In this example, it would be F1:I3.
Copy To: Specify the cell address where you want to get the list of unique records.
Copy Unique Records Only: Check this option.
Click OK.
1. filter the list in blace
2. add level
3. chart
4. Number and letters
5. advanced
plz mark me brainlist please this is urgent