Urgent Help: Find if any of the two values is included in a range of cell

[faizzsheikh]

I want to know the formula to find if any of the two values is included in a range of cell.

Example, below is a group of names (similarly I have various other groups with different names):

Column A
1. Andy
2. Susan
3. Greg
4. George
5. Peter
6. Craig


If the above group (range A1:A6) includes SUSAN OR ANDY then it must return the value as 'TRUE'

 

[Aladin Akyurek]

I want to know the formula to find if any of the two values is included in a range of cell.

Example, below is a group of names (similarly I have various other groups with different names):

Column A
1. Andy
2. Susan
3. Greg
4. George
5. Peter
6. Craig


If the above group (range A1:A6) includes SUSAN OR ANDY then it must return the value as 'TRUE'

Try...

=SUM(COUNTIF(A1:A6,{"Susan","Andy"}))>0

 

[faizzsheikh]

@Aladin Akyurek

Thanks for the help! it worked

 

[Aladin Akyurek]

@Aladin Akyurek

Thanks for the help! it worked

You are welcome. Thanks for providing feedback.