Question

what is the purpose advanced filtering in a data ​

Answer 1

Answer:

You can use Excel Advanced Filter to quickly extract unique records from a data set (or in other words remove duplicates). In Excel 2007 and later versions, there is an option to remove duplicates from a dataset.

Answer 2

Answer:

You can use Excel Advanced Filter to quickly extract unique records from a data set (or in other words remove duplicates). In Excel 2007 and later versions, there is an option to remove duplicates from a dataset.