Click the Data tab on the Ribbon. Then choose Advanced from the Sort & Filter group, and the Advanced Filter window will open. Under Action, select Copy to another location since you want our filtered ...

Excel’s Advanced Filter feature doesn’t use a dropdown list of filtering options and values. Rather, you enter criteria at the sheet level and the feature copies a filtered set to another ...