Question

Please let me know the difference between advanced filter and filter

Answer 1

Answer:

For example, with an AutoFilter, you can select two specific customers, and two products for those selected customers. With an Advanced Filter, you can create OR conditions between columns, such as Customer A OR Product B -- you can't do that in an AutoFilter!

Answer 2

Answer:

Here are some differences between the regular filter and Advanced filter: While the regular data filter will filter the existing dataset, 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.

hope it help you ✌✌☺☺