count total month per year

[Brie]

Hi all,

I have a table like this

Name submit date
A 10-Jan-2006
B 13-Jan-2006
C 25-Feb-2006
A 5-Jul-2007
D 18-Aug-2007
C 23- Oct-2007

Questions:
1. how to count the total entries of each month per year and total entries
per year, ignoring the first column; so I will have Jan-2006=2 entries,
Feb-2006=1 entries; also 2006=3 entries, etc.
2. how to count and relate the two column; so I will have A on Jan-2006
submitted 2 entries etc.

Thank you so much for your help.

Brie

 

[Peo Sjoblom]

Use a pivot table and group the dates for months

http://peltiertech.com/Excel/Pivots/pivotstart.htm

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

 

[Brie]

Peo:

Thank you for this.

Took me some time to learn and test it. I had to squeeze my brain v hard
but finally I got it. Quite fun too!

Brie