Loop through log, extract unique name, and populate table with occurrences

[pjbassdc]

Good morning everyone,

Working on data presentation. I have a log that is populated from elsewhere in the workbook. I would like to be able to have a table update itself as the log changes. In the table I need to capture each unique name and all dates associated with the name. I have a sample attached of what I hoped it would look like when working. Basically I have a place for the name and to the right, cells that represent the months of the year. The data captured has the date in mm/dd/yyyy format and I just need each monthly instance to land in the proper month column in the table. No need for date specific, just the month of the occurrence. I am finding as I learn more and more about excel, that there are many ways to get your desired result. I am open to any ideas, suggestions or solutions.

Thank you for your help,

Patrick

[FDibbins]

1st, I would change the months in F2:Q2 to real dates...1/2/14, 2/1/14 etc, you can format them to show the month names

Then, use this in E3, copied down...
=IFERROR(INDEX($C$3:$C$20,MATCH(0,INDEX(COUNTIF($E2:E$2,$C$3:$C$20),0,0),0)),"")
And then this, copied down and across to count the occurrances...
=COUNTIFS($C$3:$C$20,$E3,$A$3:$A$20,">="&F2,$A$3:$A$20,"<"&EDATE(F$2,1))

[pjbassdc]

Thank you for the reply Ford. I will try your solution a little later today. You suggested that I put in real dates for the F2:Q2. Since an occurrence can happen on any given day, do I need to make 365 different columns, one for each day? I will eventually want to tally the occurrences by month.

Thanks

Patrick