couting occurence using multiple dates in single cell
 

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200912/1