There is a source cell that can contain any combination of AA, BB, HH,
and other 2 letter text separated by commas.
For example cell A1 can have "AA, HH"
cell b2 can have "AA, BB, HH"
I want to set up a formula so that another cell can check cell a1 or b2
and see if "AA" is found in that cell and if it does, to return a "1".
If the cell does not have "AA" in it then it would return a "0." Is
this at all possible? Thanks!