Forum Discussion
Excel filtering and search
You can use Advanced Filter for this.
Elsewhere on the sheet, enter Owner and Contributor in two cells next to each other.
Enter Govt Affairs in the cell below Owner, and also two cells below Contributor:
Click in any cell of your data.
On the Data tab of the ribbon, in the Sort & Filter group, click Advanced.
Excel should automatically enter the entire data range in the 'List range box'.
Click in the 'Criteria range' box.
Point to the range as displayed above.
Click OK.
Thanks for your fast response but that doesn't do anything when I follow your instructions.
Nothing appears. Is Excel for Mac different?
This is the step before hitting OK...then no change at all.
The Criteria range should not be $A$1:$C$6 but $G$8:$H$10
HansVogelaar thanks very much that seems to have done the trick.