I am certain there is a simply way to do this but as yet, none of the excel functions i have looked up seem to do exactly what i am looking for:
Essentially i want to create a dummy value for each string in a list according to whether it is in some subset of this list. For example ...
If the subset is
red
blue
then i would like the following output
Value Dummy
Green 0
Yellow 0
Red 1
White 0
Blue 1
Black 0
Note, the list is long so ideally i would like to provide a cell range as the argument in which to search.
Any ideas?
Thanks in advance
Essentially i want to create a dummy value for each string in a list according to whether it is in some subset of this list. For example ...
If the subset is
red
blue
then i would like the following output
Value Dummy
Green 0
Yellow 0
Red 1
White 0
Blue 1
Black 0
Note, the list is long so ideally i would like to provide a cell range as the argument in which to search.
Any ideas?
Thanks in advance