Hi folks,

I have a spreadsheet where there is survey data that I need to begin
analyzing. In several of the questions there were multiple choice
answers that could be answered by any combination or just one letter.

For example, answer 3 has many that have ABD, ABC, BCD, etc.. For
analysis purposes I want to start first with the number of A's, B's,
C's etc, then look at the unique combinations. Can "countif" count
text entries, if so what would the formula look like?

Thanks,

PZan


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=386475