Find if value exits in array

G

Glynn

I need to determine if a numeric value held in a cell exists is a multy row,
multy column array of numeric values
 
M

Mike H

Try

=IF(COUNTIF(A1:D4,E1)>0,"It's there","It's not there")

Where
a1 - D4 is your array
E1 contains the number you are looking for

Mike
 
D

Dave Peterson

=COUNTIF(B3:X99,A1)
will return the number of times the value in A1 is in B3:X99.

=countif(b3:x99,a1)>0
will return true or false

change your addresses to match what you need.
 
G

Glynn

Thanks Mike
--
Regards

Glynn Taylor


Mike H said:
Try

=IF(COUNTIF(A1:D4,E1)>0,"It's there","It's not there")

Where
a1 - D4 is your array
E1 contains the number you are looking for

Mike
Click to expand...
 
G

Glynn

Thanks Dave
--
Regards

Glynn Taylor


Dave Peterson said:
=COUNTIF(B3:X99,A1)
will return the number of times the value in A1 is in B3:X99.

=countif(b3:x99,a1)>0
will return true or false

change your addresses to match what you need.
Click to expand...
 

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

Multi thread in Excel 3
Using cell reference with logical operator in DGET expression 1
Mixed numerical and textual data 4
multy master pages in power point 1
Positioning Numeric Values Resulting from 6 Column Array Formula 2
#value error for sumproduct using RIGHT cmd 0
Parameters for an excel formula 1
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row 5

Top