Are you looking for how many times a name appears in the list? If yes, just
drag Count of Dates out of the DATA area and replace it with Count of Names.

Does that help?

***********
Regards,
Ron


"Mandeep Dhami" wrote:

Thanks Ron.
I tried as instructed but sorry to say it is not working as I wanted.
The result is that, I am getting total number of times the dates are entered
against each names, where as I want that each new date should be counted only
once, i.e., if a person "A" is present for 10 days in a month, I should get
count 10 against his name no matter how many times he may have entered same
date against his name.
Hope I am able to convey what I require.

Cheers,
Mandeep Dhami


"Ron Coderre" wrote:

Have you considered a Pivot Table?

DataPivot Table
Use Excel
Select your data
Click the [Layout] button

ROW: Drag the Names field here
DATA: Drag the Dates field here
If it doesn't list as Count of Dates...dbl-click it and set it to Count
Click [OK]
Select where you want the Pivot Table...and you're done!

That will list each name and the count of dates.

To refresh the Pivot Table, just right click it and select Refresh Data.

Something you can use?

***********
Regards,
Ron


"Mandeep Dhami" wrote:

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