How to find most popular choice from a text list?

[Vidcapper]

FYI, I'm using Excel 2010

I have a column that contains a whole list of wind direction readings
'N','NE',"E", etc.

Is there a way of displaying which of the wind directions was the most
frequent, over a given range of rows in that column?

 

[Vidcapper]

FYI, I'm using Excel 2010

I have a column that contains a whole list of wind direction readings
'N','NE',"E", etc.

Is there a way of displaying which of the wind directions was the most
frequent, over a given range of rows in that column?

Should I assume there is no easy way of doing this, then?

I managed it with helper columns before, but I hoped there was a more
concise way?

TIA.

 

[Claus Busch]

Hi,

Am Thu, 26 Dec 2013 16:20:28 +0000 schrieb Vidcapper:

Should I assume there is no easy way of doing this, then?

create a Pivot table. Drag wind directions to the row field and to the
value field and select for the value field show numbers as % of result.

Regards
Claus B.

 

[Vidcapper]

Hi,

Am Thu, 26 Dec 2013 16:20:28 +0000 schrieb Vidcapper:


create a Pivot table. Drag wind directions to the row field and to the
value field and select for the value field show numbers as % of result.

Do you know of any good tutorial for Pivot Tables then, as I've never
used them before?

 

[Claus Busch]

Hi,

Am Thu, 26 Dec 2013 17:09:42 +0000 schrieb Vidcapper:

Do you know of any good tutorial for Pivot Tables then, as I've never
used them before?

no, I don't.
But have a look:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook "Wind Direction"
Perhaps the description may help


Regards
Claus B.

 

[Vidcapper]

Hi,

Am Thu, 26 Dec 2013 17:09:42 +0000 schrieb Vidcapper:


no, I don't.
But have a look:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook "Wind Direction"
Perhaps the description may help


Regards
Claus B.

Thanks for that - I may see if I can adapt my helper column set-up from
my previous spreadsheet first, though.

 

[Norman Jones]

Do you know of any good tutorial for Pivot Tables then, as I've never
used them before?

Hi Vidcapper,

As an excellent source of multiple pivot table tutorials, demos, sample
workbooks and tips, see Contextures:

http://www.contextures.com/tiptech.html


===
Regard,
Norman