Looking for some assistance on a COUNTIF function to auto sort some data. I made a quick and simple version of what im looking to do below. The top table is the whole set of data. I want it to only display the data for certain employees, and certain employees results.
What would the full function be to display only the bottom table data without using filters.
Thank You
What would the full function be to display only the bottom table data without using filters.
Thank You
Employee | Passing | Type |
Bob | 1 | a |
Bob | 1 | a |
Tommy | 1 | a |
Tim | 1 | b |
Susan | 0 | b |
Susan | 0 | a |
Eric | 1 | a |
Team Member | Passing | Type |
Bob | 1 | a |
Bob | 1 | a |
Susan | 0 | b |
Susan | 0 | a |
End Result | ||
Susan | 0 | b |
Susan | 0 | a |