Have you considered using a Pivot Table?
"jjcx" wrote:
i am trying to find a formula in excel that will find the
most frequent word from a list of words. The MODE function only works
on numbers and i wondered if any formulas worked on text. PLZ HELP -
THNX.
--
jjcx
------------------------------------------------------------------------
jjcx's Profile: http://www.excelforum.com/member.php...o&userid=36956
View this thread: http://www.excelforum.com/showthread...hreadid=566710