Forum Discussion

rebeccap2021's avatar
rebeccap2021
Copper Contributor
Nov 10, 2020

Excel filtering and search

I need help with an excel filtering solution that will allow easy search across three columns.  A simplified example is below.. Issue Owner Contributor Sustainable industrialization Manufa...
BI & Data Analysis
Excel on Mac
office 365
rebeccap2021's avatar
rebeccap2021
Copper Contributor
Nov 10, 2020

HansVogelaar 

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.

 

 

HansVogelaar's avatar
HansVogelaar
MVP
Nov 10, 2020

rebeccap2021 

The Criteria range should not be $A$1:$C$6 but $G$8:$H$10

  • rebeccap2021's avatar
    rebeccap2021
    Copper Contributor
    Nov 11, 2020

    HansVogelaar thanks very much that seems to have done the trick.

Resources