View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to determine whether a list contains a specific value?

Does anyone have any suggestions on how to determine whether a list contains
a specific value? such as
{2, 6, 8, 16, 11, 9, 16} under column A
In cell B1, there is a value 3, if 3 is contained inside the list under
column A, then return 1, else 0.
Does anyone have any suggestions?
Thank in advance for any suggestions?
Eric