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
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)>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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks