EXCEL PIVOT CHART FILTERING A FILTER HOW TO
Let us now see how to use the Advanced Filter in Excel with the help of some examples. This Advanced Filter is very simple easy to use. If you want to extract records where Reporting Manager is “Aakash Harit” or Employee name is “Vishal Kumar”, you have to extract data 2 times using a regular filter, first data having Aakash Harit is RM, and second, when Emp name is Vishal while using an advanced filter, you can extract all unique records in one go. you can’t use multiple criteria simultaneously to extract records from one dataset you have to extract data satisfying each criterion, ultimately leading to duplicity.Į.g.