What I would like Excel to do is if there is an occurence of "AAA, BBB, CCC, etc." in cell A2, I need Excel to place a "1" in the column underneath the appropriate "AAA, BBB, CCC, etc." label heading. Sorry if I didn't state the question correctly. Any further suggestions?