how to do advance filter
Answers
Answered by
2
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.
Answered by
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.
Similar questions
Math,
5 months ago
Math,
11 months ago
Math,
11 months ago
Accountancy,
1 year ago
French,
1 year ago