View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
viktor viktor is offline
external usenet poster
 
Posts: 2
Default compare a value to many other values

I want to check if a certain value (cell) is equal to any of a number of
cells (N5:AQ32). If the value equals one or more of the cells i want it to
return "1", if not return "0".

Thanks in adwance.

Viktor