Establishing most common word in an Excel column
On Feb 2, 9:30*pm, Brymor wrote:
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
You can also use Countif. Assuming your data is in Column A rows 1 to
24000 then in column B if you enter =COUNTIF($B$2:$B$24000, B2) and
drag it through the column the number of instances a particular value
repeats would be listed you can then choose for the largest number to
see which direction the wind was most of the times.
Hope that helps,
Anand
9910548139
|