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.
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.