Originally Posted by teshurtz

Better yet to be more consistent with your example. you are trying to see if a single column has more of one word than another right?
so in column D cell 1 type =countif(c:c,"text") and in D2 =countif(c:c,"text2"). then compare cell d1 and d2

or you could combine them all in cell A1 with a slightly complex "if" statement =if(countif(c:c,"text")>countif(c:c,"text2"),"text ",if(countif(c:c,"text")<countif(c:c,"text2"),"tex t2","Equal")

This will make cell A1 display the word "text" if there are more cells in column C containing "text" and A1 will display the word "text2" if there are more cells in column C containing "text2". if there are the same number of text and text 2 it will say "Equal"