FIND function for an array

F

FARAZ QURESHI

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?
 
R

Ron Coderre

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
 
R

Ron Coderre

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
 
F

FARAZ QURESHI

Great RON,

Thanx,

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

Thanx again
 
Top