•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Filter by multiple criteria?
| Employee | Manager | Status |
|---|---|---|
| Jimmy | Mike | Compliant |
| Lucy | Sarah | Non-Compliant |
| Carl | Sarah | In Process |
| Allen | Jane | Compliant |
| Stephen | Tom | Compliant |
Above is an example of the dataset I'm working with. What I would like to do is pull back a list of all managers and all employees under any manager with a "non-compliant" status, even if those employees are not non-compliant.
With the example above, I would pull back Lucy and Carl for the manager Sarah since Lucy is non-compliant.
I'm hoping there's a way to do this in PowerQuery so the result is a new filterable table, but any help is appreciated!
[link] [comments]
Want to read more?
Check out the full article on the original site