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
<tbody>
</tbody>
I want to automate the process of showing if a professor published at a specific date like this:
<tbody>
</tbody>
Can someone on the forum help me out? I can provide the original file if that will help.
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.