database
 

I have a worksheet with two columns. The first is a date column ranging
between 1st jan 2007 to 31st Dec 2007. The other is a list of functions or
events (i.e BBQ, Parents meeting,Teachers lunch and the like).
What i need is to have each month listed seperately in different columns on
the same or another sheet. Any suggestions please!!!

database
 

Say the data starts in row 2.

In C2 enter:
=MONTH(A2) and copy down
You will see a column of month numbers

Click on C1 and pull-down:

Data Filter AutoFilter

click on the pull-down and pick a month. Copy the resulting rows and paste
them on another sheet.


For example if the data was:

date text
7/15/2007 words
5/1/2007 words
8/29/2007 words
2/15/2007 words
2/22/2007 words
6/15/2007 words
6/22/2007 words
1/1/2007 words
8/14/2007 words
9/5/2007 words
4/23/2007 words
1/23/2007 words
5/16/2007 words
7/22/2007 words
4/16/2007 words
4/1/2007 words
7/7/2007 words
8/6/2007 words
6/30/2007 words

after inserting the MONTH function:

date text key
7/15/2007 words 7
5/1/2007 words 5
8/29/2007 words 8
2/15/2007 words 2
2/22/2007 words 2
6/15/2007 words 6
6/22/2007 words 6
1/1/2007 words 1
8/14/2007 words 8
9/5/2007 words 9
4/23/2007 words 4
1/23/2007 words 1
5/16/2007 words 5
7/22/2007 words 7
4/16/2007 words 4
4/1/2007 words 4
7/7/2007 words 7
8/6/2007 words 8
6/30/2007 words 6


After AutoFiltering on month 6:

date text key
6/15/2007 words 6
6/22/2007 words 6
6/30/2007 words 6

--
Gary''s Student - gsnu200739


"zacted" wrote:

I have a worksheet with two columns. The first is a date column ranging
between 1st jan 2007 to 31st Dec 2007. The other is a list of functions or
events (i.e BBQ, Parents meeting,Teachers lunch and the like).
What i need is to have each month listed seperately in different columns on
the same or another sheet. Any suggestions please!!!