database

[Guest]

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

 

[Guest]

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