First...why can I not find my previous posts? Is there a trick to finding
them?

Second.....I have a long list of data with a date field, I want to be able
to sum it up by month and year. So in one tab I have the raw data by date.
In another tab, what I want to be able to do is:

Year
2009 2010
Month
Jan ??? ???
Feb ??? ???
Mar ??? ???

Thanks
Apr
May

"First...why can I not find my previous posts? Is there a trick to finding
them?"

One way to find them is to put your user name (Paul) into the Search For:
box and then hit Go.

This will echo back with the the postings that it has found in the
particular section (for example Excel General Questions).

Please hit Yes if my comments have helped.

Thanks.




"Paul" wrote:

First...why can I not find my previous posts? Is there a trick to finding
them?

Second.....I have a long list of data with a date field, I want to be able
to sum it up by month and year. So in one tab I have the raw data by date.
In another tab, what I want to be able to do is:

Year
2009 2010
Month
Jan ??? ???
Feb ??? ???
Mar ??? ???

Thanks
Apr
May

Hi Paul

I am assuming you have Dates in column A and some data in column B, and that
A1 are labelled Date and Values
Place cursor in A1DataPivot TableFinish
On the PT skeleton that appears on a new page,
drag Date from the Field list to the Row area
drag Values to the Data area

Place cursor on the first date in the PTRight clcikGroup and OutlineGroup
Select Month AND YearOK
Drag Year to the Column area

--
Regards
Roger Govier

"Paul" wrote in message
...
First...why can I not find my previous posts? Is there a trick to finding
them?

Second.....I have a long list of data with a date field, I want to be able
to sum it up by month and year. So in one tab I have the raw data by
date.
In another tab, what I want to be able to do is:

Year
2009 2010
Month
Jan ??? ???
Feb ??? ???
Mar ??? ???

Thanks
Apr
May


__________ Information from ESET Smart Security, version of virus
signature database 4738 (20100102) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4738 (20100102) __________

The message was checked by ESET Smart Security.

http://www.eset.com

http://groups.google.com/groups/prof...6ViNdSJ06mlt_A
--
Gary''s Student - gsnu200909


"Paul" wrote:

First...why can I not find my previous posts? Is there a trick to finding
them?

Second.....I have a long list of data with a date field, I want to be able
to sum it up by month and year. So in one tab I have the raw data by date.
In another tab, what I want to be able to do is:

Year
2009 2010
Month
Jan ??? ???
Feb ??? ???
Mar ??? ???

Thanks
Apr
May