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