Hi,

I have a database where in dates are repeated in column D and names in
column I.
I want a formula in a different worksheet of the same file wherein I get the
count of dates column along with the individual name.
The intention is to get number of days each individual is present. The same
dates could be repeated any number of times for the same individual.

Example for the month of Dec. 2005
Dates Names
20 AD
15 BC
08 GH........etc

Cheers,
Mandeep Dhami