1.

What Is An Advanced Filter In Excel?

Answer»

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.

Here are some differences between the regular filter and advanced filter:

  • While the regular data filter will filter the EXISTING data set, you can use Excel advanced filter to EXTRACT the data set to some other location as well.
  • Excel Advanced Filter allows you to use complex criteria. For example, if you have SALES data, you can filter data on a criterion where the sales rep is Bob and the region is either North or SOUTH.

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.

Here are some differences between the regular filter and advanced filter:


Discussion

No Comment Found

Related InterviewSolutions