Counting # of events per day`

[Elliott Alterman]

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

 

[Roger Govier]

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

 

[Elliott Alterman]

Excellent - thanks!