Filter Function with And

[cstickman]

Hello Excel Users,

I seem to run into an issue with my Filter function. I am trying to add a few AND to it. Below is what I have and it keeps returning as "No Results"

Formula:
FILTER(Tracker!A1:V887,ISNUMBER(FIND(Assignments!A5,Tracker!C1:C887))*ISNUMBER(FIND(Assignments!A6,Tracker!C1:C887)),"No Results")

Additional Notes:
I am using ISNUMBER and FIND because I need to be like the data in Assignments A5. The data is task and subtasks and I need it to capture all tasks and subtasks. Any assistance would be greatly appreciated. Thanks!!

 

[Fluff]

Are you sure you want AND rather than OR?

 

[awoohaw]

Do you need both conditions in A5 and A6 to be true?

 

[cstickman]

Are you sure you want AND rather than OR?

it is AND because an owner can be assigned to multiple tasks and I need to ensure to capture all of them.

 

[cstickman]

Do you need both conditions in A5 and A6 to be true?

Yes and others. I just gave two examples. It seems if I change "*" to "+" it works.

 

[Fluff]

It seems if I change "*" to "+" it works.

That means that it is an OR condition, rather than AND

 

[cstickman]

That means that it is an OR condition, rather than AND

LOL, at times, you need to write it out. I figured the mistake when I read does it need to be AND or OR. Thank you!!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[smozgur]

I figured the mistake when I read does it need to be AND or OR. Thank you!!

The marked solution has been changed accordingly.. No further action is required for this thread.