View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LastPhilippe LastPhilippe is offline
external usenet poster
 
Posts: 1
Default Function neede which checks if a value in a cell is in a defined s

Hello,

example:
I have a row where can be the names of animals: cow, cat, dog, frog, ...
To analyse the content against some special values, eg. pets(cat, dog), I
need a function which returns true (or 1) and false (or 0):
is_in_set(b$2$;pets)
or
is_in_set(b$2$;(cat,dog))

Any idea?
--
LastPhilippe Johannes