This one's got me stumped so any help would be appreciated.

Here's the problem, I've got one column with names in it and a second column with dates in it. What I'm trying to do is generate a count in a third column next to each name with the number of times the name appears in the name column when there is a date in the corresponding date column. If the date column is blank I want the count column to remain blank.

For example:

Assigned To: Number Completed Date



I know that there will be repeated info but the end user doesn't care.

Thanks
Jeff