Hi There,
I'm trying to get the following equation to work across several sheets;
I would like to count the number of times a name appears given month and year. For example, Mark appears twice in july in 2010.
My spreadsheet is as follows:
A B
21-Jul-10 Mark
29-Jul-10 Pippa, Gerri, Mark...