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
[TABLE="width: 500"]
<tbody>[TR]
[TD]Professor Name[/TD]
[TD]Date of Publication[/TD]
[/TR]
[TR]
[TD]Kim Tae Young[/TD]
[TD]1 April 2012[/TD]
[/TR]
[TR]
[TD]Bob Collins[/TD]
[TD]1 April 2012[/TD]
[/TR]
[TR]
[TD]Samuel Jackson[/TD]
[TD]1 April 2012[/TD]
[/TR]
[TR]
[TD]Joseph Stilwell[/TD]
[TD]1 April 2012[/TD]
[/TR]
[TR]
[TD]Kim Tae Young[/TD]
[TD]10 February 2009[/TD]
[/TR]
</tbody>[/TABLE]


I want to automate the process of showing if a professor published at a specific date like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]1 April 2012[/TD]
[TD]10 February 2009[/TD]
[/TR]
[TR]
[TD]Kim Tae Young[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Bob Collins[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Samuel Jackson[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Joseph Stilwell[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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"


[TABLE="width: 328"]
<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>[TR]
[TD="width: 185"]Count of Date of Publication[/TD]
[TD="width: 113"]Column Labels[/TD]
[TD="width: 60"][/TD]
[TD="width: 79"][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD="class: xl64, align: right"]10-Feb-09[/TD]
[TD="class: xl64, align: right"]1-Apr-12[/TD]
[TD="class: xl64"]Grand Total[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Bob Collins[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Joseph Stilwell[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Kim Tae Young[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl63, bgcolor: transparent"]Samuel Jackson[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl63"]Grand Total[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5



[/TD]
[/TR]
</TBODY>[/TABLE]

 

[vogel997]

[TABLE="width: 377"]
<colgroup><col width="503" style="width: 377pt; mso-width-source: userset; mso-width-alt: 18395;"> <tbody>[TR]
[TD="width: 503, bgcolor: transparent"]=COUNTIFS($A$2:$A$6,$A9,$B$2:$B$6,B$8) -> a9 references the name and b8 references the date.
[/TD]
[/TR]
</tbody>[/TABLE]

 

[EPTowers]

[TABLE="width: 377"]
<tbody>[TR]
[TD="width: 503, bgcolor: transparent"]=COUNTIFS($A$2:$A$6,$A9,$B$2:$B$6,B$8) -> a9 references the name and b8 references the date.[/TD]
[/TR]
</tbody>[/TABLE]

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