View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brymor Brymor is offline
external usenet poster
 
Posts: 17
Default Establishing most common word in an Excel column

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