look for true, false, when an array is emty or not

M

Mauricio

plz. I need to find a way to retorned a false, true when
the array contine the maching reference or not.
 
B

Biff

Hi Mauricio,

I think this may be what you're after. The array being in
A1:A100 and the reference to match in E1.

=IF(COUNTIF(A1:A100,E1),TRUE,FALSE)

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
VBA word change keys 0
Macro to Select text from a point given to a specific word 2
Need help finding a substring in a array of strings. 1
VBA to look for more than 1 key word and highlights 8
Vlookup error 1
check if 2 cells are equal but only if they contain numbers not i. 4
SUMIF "value if false" not working 2

Top