Please help....

Entering data to Excel as 1 (yes) or 0 (no) in columns as responses to
yes/no questions in the rows. I wish to then identify those columns with yes
(1) answers in several categories but not in others.

Thank you