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. Regular Filter is a sequential filter viz.The advanced filter can be used to extract unique entries in our dataset.A regular filter will filter data on the existing dataset, while with the latter, you can extract data to some other location keeping original data intact.(I will explain in detail with an example.) You can use the advanced filter for more complex criteria filtering.What is the difference between regular and advanced filter? TEXT and String Functions in Excel (26+)Įxcel functions, formula, charts, formatting creating excel dashboard & others.Lookup and Reference Functions in Excel (36+).Excel Conditional Formatting in Pivot Table.
0 kommentar(er)
