Count unique entries with conditions

Closed
Report
Posts
3
Registration date
Sunday September 16, 2012
Status
Member
Last seen
September 17, 2012
-
Hello,

I have two columns of names. I need to count the number of unique names in column A for each individual name and year in columns B and C.

Basically, I need to calculate the number of unique "Leads" in column A given a specific participant and year.

I hope, that the following file will illustrate my problem:

http://speedy.sh/HzE4V/Number-of-unique-entries.xlsx

Could anyone help me on this?