Counting # of events per day`

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elliott Alterman - 19 Sep 2006 16:04 GMT

I have a file with the following format

col a        event name
col b        event date (e.g., 9/01/2006)
col c        event day of week (Mon, Tu, etc)
col d, etc    other info

There are about 1600 of them.

I need to get the following info:

Number of days throughout the year with 0, 1, 2, 3, or 4 or more events per day
Similar results for Mondays, Tuesdays, etc.

Any suggestions on how to go about doing that?

Thanks

Reply to this Message

Roger Govier - 19 Sep 2006 16:35 GMT

Hi Elliott

Create a Pivot Table.
Data>Pivot Table>Next>Mark the range of your data>Next>Layout
Drag Event day of Week to Column Area
Drag Event Date to Row area
Drag Event Name to Data area it should show as Count of Event Name, if
not double click the filed heading and change to count

Click OK>Finish

If you want to aggregate your data into Months, then Right click on
Date>Group>Select Year AND Month

For more help on the use of Pivot Tables visit Debra Dalgleish's site
and scroll to Pivot Tables
http://www.contextures.com/tiptech.html

Signature

Regards

Roger Govier

>I have a file with the following format
>
[quoted text clipped - 14 lines]
>
> Thanks

Reply to this Message

Elliott Alterman - 19 Sep 2006 17:48 GMT

Excellent - thanks!

> Hi Elliott
>
[quoted text clipped - 13 lines]
> and scroll to Pivot Tables
> http://www.contextures.com/tiptech.html

Reply to this Message