Find if value exits in array
Thanks Dave
--
Regards
Glynn Taylor
"Dave Peterson" wrote:
=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.
Glynn wrote:
I need to determine if a numeric value held in a cell exists is a multy row,
multy column array of numeric values
--
Regards.
Glynn Taylor
--
Dave Peterson
|