tracking activity

[EPTowers]

I have an excel file with the names of the professors, and the dates of their publications. I want to use the file analyze publications put forth my university's faculty.
Here is what is in the original sheet with base data:
column A: professors' names
column B: date of publication

Professor Name	Date of Publication
Kim Tae Young	1 April 2012
Bob Collins	1 April 2012
Samuel Jackson	1 April 2012
Joseph Stilwell	1 April 2012
Kim Tae Young	10 February 2009

<tbody>
</tbody>

I want to automate the process of showing if a professor published at a specific date like this:

	1 April 2012	10 February 2009
Kim Tae Young	1	1
Bob Collins	1	0
Samuel Jackson	1	0
Joseph Stilwell	1	0

<tbody>
</tbody>

Can someone on the forum help me out? I can provide the original file if that will help.

 

[liveinhope]

use pivot tables


Row labels - Professor name

Column labels - date of publication

values - count of "date of publication"

Count of Date of Publication	Column Labels
Row Labels	10-Feb-09	1-Apr-12	Grand Total
Bob Collins		1	1
Joseph Stilwell		1	1
Kim Tae Young	1	1	2
Samuel Jackson		1	1
Grand Total	1	4	5

<COLGROUP><COL style="WIDTH: 139pt; mso-width-source: userset; mso-width-alt: 6765" width=185><COL style="WIDTH: 85pt; mso-width-source: userset; mso-width-alt: 4132" width=113><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><TBODY>
</TBODY>

 

[vogel997]

=COUNTIFS($A$2:$A$6,$A9,$B$2:$B$6,B$8) -> a9 references the name and b8 references the date.

<colgroup><col width="503" style="width: 377pt; mso-width-source: userset; mso-width-alt: 18395;"> <tbody> </tbody>

 

[EPTowers]

=COUNTIFS($A$2:$A$6,$A9,$B$2:$B$6,B$8) -> a9 references the name and b8 references the date.

<tbody>
</tbody>

Thank you so much! You solved my problem. This perfect, I really appreciate your help.