Compare one Column to a Second Column Formula Help Needed

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

See other thread

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jeffc" <jeffc.267hqq_1144937412.4266@excelforum-nospam.com> wrote in
message news:jeffc.267hqq_1144937412.4266@excelforum-nospam.com...
>
> 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
>
>
> --
> jeffc
> ------------------------------------------------------------------------
> jeffc's Profile:
http://www.excelforum.com/member.php...o&userid=33452
> View this thread: http://www.excelforum.com/showthread...hreadid=532622
>