couting occurence using multiple dates in single cell

  • Thread starter tabylee via OfficeKB.com
  • Start date
T

tabylee via OfficeKB.com

Hi,

I need to count the no. of meeting that took place in each month.

My worksheet is
January Feb to Dec
column A column B Column C to Column M Column C (data)
1 name no of meeting No of meeting
2 Jack 1/1/09,
1/3/09, 2/1/09,

2/5/09, 3/1/09.4/1/09

3 Peter 2/1/09,
3/1/09,3/15/09

4 Paul 3/1/09,
4/1/09, 4/2/09

is there a way to count the
1. total no. of meeting?
2. total no. of meeting in one month?

I did see one almost similarin forum, but answer will be in rows not in
column. I need the answer to be in one row - in line with the name of person.


Hope someone may be able to help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top