Advanced filter steps pls
Answers
Answered by
0
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
0
Answer:
in the Advanced Filter dialog, select the list you want to filter. Click in Criteria range. Select the criteria, in this case G1 through H2. Click OK, and the range is filtered using the criteria.
Similar questions