Question

What is Advance Filtering?How can it be applied on a table in a datesheet​

Answer 1

Answer:

With an Excel Advanced Filter, you can filter the data in place, or to a different location. When applying the advanced filter, you can specify that you want to see unique items only. With that option selected, all the duplicates are removed from the filtered list.

Explanation:

hope it helps