Hi
I am looking for a formula that helps with the scenario below please
i have a table that has a persons name in A1 and a date in C1 in format dd/mm/yyyy
what i am after is to count the number of times that persons name appears in a particular month
eg.
Name Date
Smith 01/01/2014
Smith 05/02/2014
Jones 08/01/2014
Smith 31/01/2014
so in the table above answers should be
Smith Jones
Jan 2 1
Feb 1 0
Any help please?
Bookmarks