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!