I'm having some difficulty figuring out a formula for this one. Using the data in the below table, I want to write a formula that will tell me how many Days Worked (unique records) I have for each person: Dan, Frank, and James.
The results should show that Dan = 4, Frank = 6, and James = 1.
--------------------------------------------------------------------------------
A B C 1 Name Date Mins 2 Dan 6/10/2012 22 3 Dan 6/10/2012 24 4 Dan 6/10/2012 20 5 Dan 6/11/2012 25 6 Dan 6/12/2012 14 7 Dan 6/13/2012 19 8 Dan 6/13/2012 20 9 Frank 6/9/2012 30 10 Frank 6/9/2012 26 11 Frank 6/10/2012 15 12 Frank 6/11/2012 20 13 Frank 6/12/2012 14 14 Frank 6/13/2012 20 15 Frank 6/14/2012 12 16 James 6/10/2012 13 17 James 6/10/2012 14 18 James 6/10/2012 30 19 James 6/10/2012 20 20 James 6/10/2012 23
--------------------------------------------------------------------------------
Book1.xlsx
Bookmarks