How do you use a simple filter on data??????
Answers
Answered by
6
On the Data tab, in the Sort & Filter group, click Advanced, and adjust the Criteria range to range A1:E3 (blue). Note: always place a formula in a new column. Do not use a column label or use a column label that is not in your data set. Create a relative reference to the first cell in the column (B6).
Similar questions