close
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
With your values in A1:A10 and your value to search for (4) in B1 try
this:
=COUNTIF(A1:A10,B1)gt;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: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=497082
全站熱搜
留言列表
