Abdul Alim: a little bit learning, let's go
Excel, VBA and Power BI tutorials
Abdul Alim: a little bit learning, let's go
Excel, VBA and Power BI tutorials
Advanced filter provides the more flexibility to filter the data in Excel. You can extracts the filtered record on the same or another worksheet/workbook.
We can give the filter fields and criteria on the worksheet.
For example we have to filter the Supervisor-1 data in below image.
Click on Advanced button available in Data Tab (Highlighted in above picture)
Advanced filter window will be opened
Here you can given List range, which is the data range.
Criteria range is the Field Name and Criteria
Click on OK
Data will be filtered
You can give the multiple fields and criteria. Let’s say we have to filter for Supervisor-1 wherein Sales are greater than 10.
Put the Criteria as given in below image.
Below is the filter result.
We can get the unique records also by using the Advanced Filter in Excel.
Select the column and go to Data Tab>>Advanced Filter
You can copy the unique record in any other column also.
Tick the Unique records only check box
Below is the advanced filter result