EPTowers

New Member
Joined
Jan 25, 2014
Messages
5
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 NameDate of Publication
Kim Tae Young1 April 2012
Bob Collins1 April 2012
Samuel Jackson1 April 2012
Joseph Stilwell1 April 2012
Kim Tae Young10 February 2009

<tbody>
</tbody>


I want to automate the process of showing if a professor published at a specific date like this:
1 April 201210 February 2009
Kim Tae Young11
Bob Collins10
Samuel Jackson10
Joseph Stilwell10

<tbody>
</tbody>

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

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

liveinhope

Well-known Member
Joined
Dec 16, 2013
Messages
857
use pivot tables


Row labels - Professor name

Column labels - date of publication

values - count of "date of publication"


Count of Date of PublicationColumn Labels
Row Labels10-Feb-091-Apr-12Grand Total
Bob Collins11
Joseph Stilwell11
Kim Tae Young112
Samuel Jackson11
Grand Total145




<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

Active Member
Joined
Jan 22, 2010
Messages
412
=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>
 

Watch MrExcel Video

Forum statistics

Threads
1,123,323
Messages
5,600,954
Members
414,417
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top