if it is a fixed string you are looking to compare, you could make a column next to each (even hidden afterwords). in the first cell of column b (assuming the data is in column a) type =if(a1="text",1,0) and then drag that to the bottom of the list. copy and paste that same column of formulas next to the other list. then just sum the two columns to compare them.

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"