A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Information for Pivot Table



 
 
Thread Tools Display Modes
  #1  
Old June 1st, 2010, 08:55 PM posted to microsoft.public.excel.misc
HL
external usenet poster
 
Posts: 26
Default Information for Pivot Table

I have a column with the following information:
F2=1/3/2010
F3=1/15/2010
F4=2/14/2010
and so on

I'm creating a Pivot Table to display this information and right now it
shows each week. I really want to the Pivot Table to show the data based on
the month.

How do i take the information above (e.g. 1/3/2010) and create a column that
will only show Jan, Feb, Mar, etc.

So essentially i want to say IF F2=mm/dd/yyyy then G2=Jan

thanks
  #2  
Old June 1st, 2010, 09:34 PM posted to microsoft.public.excel.misc
Tom Hutchins
external usenet poster
 
Posts: 722
Default Information for Pivot Table

In an empty column adjoining your data, try:
=TEXT(F2,"mmm")
and copy down.

Hope this helps,

Hutch

"HL" wrote:

I have a column with the following information:
F2=1/3/2010
F3=1/15/2010
F4=2/14/2010
and so on

I'm creating a Pivot Table to display this information and right now it
shows each week. I really want to the Pivot Table to show the data based on
the month.

How do i take the information above (e.g. 1/3/2010) and create a column that
will only show Jan, Feb, Mar, etc.

So essentially i want to say IF F2=mm/dd/yyyy then G2=Jan

thanks

  #3  
Old June 1st, 2010, 10:11 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Information for Pivot Table

As long as each entry in that field is a date (no empty cells and no text), then
you can create the pivottable and group the data by months (and years (I bet)).

Rightclick on the field (in the PT)
Select "Group and show detail",
Then Group.



HL wrote:

I have a column with the following information:
F2=1/3/2010
F3=1/15/2010
F4=2/14/2010
and so on

I'm creating a Pivot Table to display this information and right now it
shows each week. I really want to the Pivot Table to show the data based on
the month.

How do i take the information above (e.g. 1/3/2010) and create a column that
will only show Jan, Feb, Mar, etc.

So essentially i want to say IF F2=mm/dd/yyyy then G2=Jan

thanks


--

Dave Peterson
  #4  
Old June 1st, 2010, 10:11 PM posted to microsoft.public.excel.misc
Roger Govier[_8_]
external usenet poster
 
Posts: 338
Default Information for Pivot Table

Hi

Within the PT, highlight any cell with a dateright clickGroup &
OutlineGroupMonths

--
-------
Regards
Roger Govier

"HL" wrote in message
...
I have a column with the following information:
F2=1/3/2010
F3=1/15/2010
F4=2/14/2010
and so on

I'm creating a Pivot Table to display this information and right now it
shows each week. I really want to the Pivot Table to show the data based
on
the month.

How do i take the information above (e.g. 1/3/2010) and create a column
that
will only show Jan, Feb, Mar, etc.

So essentially i want to say IF F2=mm/dd/yyyy then G2=Jan

thanks

__________ Information from ESET Smart Security, version of virus
signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.