Detect Presence Formula

G

Guest

I need a formula that will detect the presence of a value in an unsorted
named array.

Column A would be the named array.
Column B would be the value I want to test for.
Column C would be the formula.

So, this is sort of what it would look like. "D" is the only value that
would return a True because it is the only value present in the named array.

D I False
B O False
W D True
T A False
J P False

Anyone know how to do this?
 
G

Guest

Try something like this:

With your posted data in A1:B5

C1: =(COUNTIF($A$1:$A$5,B1)>0)
copy that formula down through C5

or...if you want to search the entire column
=(COUNTIF(A:A,B1)>0)


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

XL2002, WinXP
 
G

Guest

Hey! That seems to work. Thanks!

Ron Coderre said:
Try something like this:

With your posted data in A1:B5

C1: =(COUNTIF($A$1:$A$5,B1)>0)
copy that formula down through C5

or...if you want to search the entire column
=(COUNTIF(A:A,B1)>0)


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

XL2002, WinXP
Click to expand...
 
G

Guest

Thanks for the feedback.....I'm glad that worked for you.

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

XL2002, WinXP
 

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

Scrabble Value calculation for Welsh words 0
Array formaul with OR condition 0
LOOKUP returning wrong values 2
concatenate in array formula? 1
With F1 value, look at A, if match or partial match return B 5
Vlookup and retrieve values 1 row below the normally retrieved val 2
speeding up calculation: replacing array formula with databasefunction? 9
IF formula 1

Top