View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kimti Kimti is offline
external usenet poster
 
Posts: 38
Default Formula to sum up the dates

I have column A with the date and column B with the name of person assigned
for the task. I would like to count how many tasks assigned to any particular
person for whole month based on column A dates.

A B
Jan 10, 2010 John C
Jan 12, 2010 Jason B
Jan 13, 2010 John C

John C was assigned two tasks in Month of Jan. Usally I have about 80 tasks
for 11 employees per month.

Thank you in advance for your help.