You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Brymor" wrote in message
...
Many thanks Biff, works a treat!
Just copied / pasted your formula into cell, changed the range details and
BINGO, I got what I wanted.
--
Thanks and kind regards,
Brymor


"T. Valko" wrote:

With your data in the range A2:A13, this array formula** returns SE as
the
most frequent TEXT entry:

=INDEX(A2:A13,MODE(MATCH(A2:A13,A2:A13,0)))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the
SHIFT
key then hit ENTER.

Note that if there are an equal number of entries for more than one
direction the formula will return the direction that appears first from
top
to bottom. For example:

NE
NE
SW
SW
SSW

The formula result will be NE. Both NE and SW appear the most often but
NE
appears first in the list.

--
Biff
Microsoft Excel MVP


"Brymor" wrote in message
...
Using Office 2003.
In my weatherstation data, [very long listings over 12 months x 4
readings
per day ], the wind's direction changes are listed as:-
NORTH, NE,SE,SE,EAST,ENE,WSW,SOUTH,SE,EAST, NW, WNW, and so on.
I would like to find a formula that will tell me the most prolific word
in
the column list.
I hope that someone can help me here.
Thanks and kind regards,

Brymor


.