I have columns in an excel spreadsheet with thousands of rows of data that is based on date e.g. 01-JUN-03 or 10-JUN-03.
I need to count how many rows are present per month.
This can be done quite simply with a Pivot Table. In the Pivot Table Wizard setup, you will drag the date into either the ROW or COLUMN area and in the DATA area.
In the DATA area, specify that you want a Count.
Finish the Pivot Table Wizard, and right click on the Date heading in the Pivot Table, selecting Group. Select Months and ...
VOLA!
It took me less than 30 seconds, creating some test data and creating the Pivot table that counts by months.
If you need to discriminate my Year as well (ie June 2003 does NOT count with June 2002) then ALSO select Year in the Group Window.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.