•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
Tagged with
#financial modeling with spreadsheets
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#large dataset processing
#Excel alternatives
#Non-Compliant
#Employee
#Manager
#Status
#Compliant
#PowerQuery
#Filter
#Compliance
#In Process
#Table
#Dataset
#Criteria