EXCEL: Check for Multiple Values

Question

I'm trying to check for multiple values using the FILTER function. Here is my code:

=FILTER(Projects!$A$2:$P$51,Projects!$E$2:$E$51="Completed")

I would like to check for additional values besides Completed. Like, Canceled, or Review.

Additionally, if I could check for a portion of case-insensitive text like, "rev" that could help too.

Scott Craner · Accepted Answer · 2023-01-30 23:23:54Z

1

Use ISNUMBER(MATCH(...))

=FILTER(Projects!$A$2:$P$51,ISNUMBER(MATCH("*"&Projects!$E$2:$E$51&"*",{"Completed","Canceled","Review"},0)))

answered Jan 30, 2023 at 23:23

Scott Craner

153k10 gold badges52 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Scott Craner · Accepted Answer · 2023-01-30 23:31:06Z

0

FILTER used to return multiple criteria

In this case, we're using the multiplication operator (*) to return all values in our array range (A5:D20) that have Apples AND are in the East region:

=FILTER(A5:D20,(C5:C20=H1)*(A5:A20=H2),"")

Also you can have a detail look at the given link

https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759

Please see the image if you do not understand

https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759

edited Jan 30, 2023 at 23:31

Scott Craner

153k10 gold badges52 silver badges88 bronze badges

answered Jan 30, 2023 at 23:27

Waqar Hassan

12 bronze badges

1 Comment

Scott Craner Over a year ago

is this a chatGPT response?

Collectives™ on Stack Overflow

EXCEL: Check for Multiple Values

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related