Question

what is the difference between filter and advanced filter options

Answer 1

Filters and advanced filtering. Excel gives you many options when it comes to filtering your data. ... Then, when you remove the filter, you have all of your data. Built in comparison operators such as “greater than”, “less than”, “between”, “top 10” or even custom filters can show the data you want and hide the rest.