Hi all,

How can I list the most common word in a given range? I have office 2007, if
this matters. The range could all potentially carry the same value, or there
could be blank lines as well, so considering the blank line issue would be
appreciated. Thanks for the help!

Try this array formula** :

=INDEX(A1:A20,MODE(IF(A1:A20<"",MATCH(A1:A20,A1:A 20,0))))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"BryGuy77" wrote in message
...
Hi all,

How can I list the most common word in a given range? I have office 2007,
if
this matters. The range could all potentially carry the same value, or
there
could be blank lines as well, so considering the blank line issue would be
appreciated. Thanks for the help!

Hi,

For some reason, using MODE doesn't work for me with text, perhaps because
I'm using Excel 2003?

This similar array formula seems to do the trick.

{=INDEX(A1:A20,MATCH(MAX(COUNTIF(A1:A20,A1:A20)),C OUNTIF(A1:A20,A1:A20),0))
}

Dave

url:http://www.ureader.com/msg/103456964.aspx