Question

_ filter option in used for most complex criteria

Answer 1

Answer:

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.