Question

how to do advance filter​

Answer 1

Answer:

Select the entire data set (including the headers).

Go Data tab –> Sort & Filter –> Advanced. (You can also use the keyboard shortcut – Alt + A + Q). ...

In the Advanced Filter dialog box, use the following details: Action: Select the 'Copy to another location' option. ...

Click OK.

Answer 2

EXCEL ADVANCED FILTER (Examples)

Select the entire data set (including the headers).

Go Data tab –> Sort & Filter –> Advanced. (You can also use the keyboard shortcut – Alt + A + Q). ...

In the Advanced Filter dialog box, use the following details: Action: Select the 'Copy to another location' option. ...

Click OK.