describe the role of advanced filtering
Answers
Answered by
4
Answer:
The Advanced filter is used to filter a data set, depending on user-defined criteria, that can be applied to several columns of data simultaneously. These criteria are specified on the same spreadsheet as the range to be filtered, rather than in a drop-down menu. The range of cells that you want to filter.
Answered by
0
Answer:
Use an Advanced Filter in Excel to create a list of unique items, or to extract specific items to a different worksheet. You can also use complex criteria with an Advanced Filter, so it is useful when a simple AutoFilter can't do what you need.
I HOPE IT HELPS TO YOU
PLZZ MARK MY ANSWER AS BRILLIANT
Similar questions