Hi all,

I'm turning in my master's thesis today and it's all done EXCEPT one very annoying, aggravating statistic I can't seem to figure out how to get on Excel. I'll tell you what I have, and what I need, and hopefully you can show me the light. It's due at 5 p.m.!

WHAT I HAVE:

I did a content analysis of speeches, and I have several columns that have a "1" or "0" indicating whether or not a particular item is present in that particular speech. They are columns F, H, J, K, L, M, O, Q, S, T, U, V and W. My column "Z" is the independent variable, and I only need to analyze all of the speeches that have a "1" in that column.

Finally, each speech has a "1" or "0" indicating whether its a Republican or Democrat speaking, in column D.

I want to do one analysis for each party for every row that has a "1" in Column Z. What I want to find is which rows have a "1" in Column Z and "1" in at least one of the other several columns I mentioned. I'll do this for values "1" AND "0" in Column D.

Does anyone have any idea how to help me?