Compare one Column to a Second Column Formula Help Needed

  • Thread starter Thread starter jeffc
  • Start date Start date
J

jeffc

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)
 
Back
Top