Which function to check any value existed withing a list?
 

Does anyone know which function to perform checking any value within a list?
such as
a list {1,2,3,4,5,6,7,8,9}
a value {4}
then return true
Thank you
Eric

Which function to check any value existed withing a list?
 

With your values in A1:A10 and your value to search for (4) in B1 try
this:

=COUNTIF(A1:A10,B1)0

This will return TRUE if there is a 4 (or any other value you put in
B1) in the list and FALSE if that value is not in the list.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=497082