Uniue Values from 2 colums - Formula

I am trying to determine the amount of days an employee has been at work. The employee's name & date can occur multiple times in the list of data. I would imagine you would need to find the unique number of occurences from a concatination between the 2 but that's not working for me.
I would really appreciate it if i could use the formula for each employee...
that way i could just copy the formula and reference the person's name.

EG. Uniue days where employee name = "Rich Armstrong" (Answer should be 3)
Uniue days where employee name = "Luke Siedle" (Answer should be 2)

Here's the data...

Date Name
2011/04/01 Rich Armstrong
2011/04/01 Luke Siedle
2011/04/01 Rich Armstrong
2011/04/01 Rich Armstrong
2011/04/01 Rich Armstrong
2011/04/01 Rich Armstrong
2011/04/01 Luke Siedle
2011/04/01 Luke Siedle
2011/04/01 Luke Siedle
2011/04/01 Luke Siedle
2011/04/01 Luke Siedle
2011/04/04 Rich Armstrong
2011/04/04 Rich Armstrong
2011/04/04 Rich Armstrong
2011/04/04 Rich Armstrong
2011/04/04 Rich Armstrong
2011/04/04 Rich Armstrong
2011/04/04 Luke Siedle
2011/04/04 Luke Siedle
2011/04/04 Luke Siedle
2011/04/04 Luke Siedle
2011/04/05 Rich Armstrong
2011/04/05 Rich Armstrong
2011/04/05 Rich Armstrong

Assuming your data is in A2:B25 and your lookup criteria is in E2, try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down if desired to get more name counts.

Add a header row

Suggest type =A2& "|" & B2 into C2 and copy down.

Copy column C and paste special - values into column E.

Copy E1 to G1

Select column E and Data-Filter - Advanced Filter. Specify column E as the list range, G1:G2 as criteria, I1 as copy to and tick unique records only.

Unique set of reords will appear in column I.

It should work in xl2010 too. Did you confirm the formula with the CTRL and Shift keys and then Enter.

Perhaps your version of Excel requires argument separators to be semi colons instead of commas. Try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save