FIND function for an array

[Guest]

Following is the column data:
A
1 America
2 Britain
3 UAE
4 Saudia

Do I have a choice to use an array formula using the FIND function to be
placed in B1 so as to evaluate if there exists an "m" in any cell of the
array A1:A4?

Similarly, do I have a choice to use an array formula using the FIND
function to be placed in B1 so as to evaluate if there exists an "a" in all
the cells of the array A1:A4?

 

[Guest]

If you only want to know if those conditions exist
try something like this:

Test if any cell in A1:A4 contains an "m"
B1: =COUNTIF(A1:B4,"*m*")>0

Test if ALL cells in A1:A4 contain an "a"
B1: =COUNTIF(A1:B4,"*a*")=ROWS(A1:B4)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

Typos!...(sorry)

The references to A1:B4
should be A1:A4

These are correct:

Test if any cell in A1:A4 contains an "m"
B1: =COUNTIF(A1:A4,"*m*")>0

Test if ALL cells in A1:A4 contain an "a"
B1: =COUNTIF(A1:A4,"*a*")=ROWS(A1:A4)


***********
Regards,
Ron

XL2002, WinXP

 

[Guest]

Great RON,

Thanx,

Never had an idea how to use an asterik in "" in Countif function.

Thanx again