Keith wants to use the Excel FILTER function to get all names where two conditions are true: Status is A and the Project does not start with 22-05. This video shows how to combine 2 conditions in an Excel FILTER formula.
Transcript of the video:
Keith wants to know.
He wants to FILTER this data over here. Everything where Status is equal to A.
And the contract, the 1st 5 characters of contract are not 22-05.
So we're going to use =FILTER(, the database. And then because we have two conditions that we're joining with an AND. Parentheses, the first condition times parentheses, the second condition. Here's the formula up here.
So there's our database. First condition D2 to D4989 equal to A.
And then this one is tricky. The second condition, the LEFT of C2 to C4989, comma 5 is not equal to 22-05. You see, they're right there.
That 2205 does not show up even though the status is A.
The first record we get is the 23-0739.
He wants to FILTER this data over here. Everything where Status is equal to A.
And the contract, the 1st 5 characters of contract are not 22-05.
So we're going to use =FILTER(, the database. And then because we have two conditions that we're joining with an AND. Parentheses, the first condition times parentheses, the second condition. Here's the formula up here.
So there's our database. First condition D2 to D4989 equal to A.
And then this one is tricky. The second condition, the LEFT of C2 to C4989, comma 5 is not equal to 22-05. You see, they're right there.
That 2205 does not show up even though the status is A.
The first record we get is the 23-0739.
