Can i pull text with a Getpivottable formula?

=?Utf-8?B?Sm9uYXRoYW4=?=

Guest

Posts: n/a

14th Sep 2006

Can text be pulled from a pivot table like numerical data? If my data fields
are Month, Days, and Amounts and my pivot table looks something like this:

Month Day Amount
January Monday 10
Tuesday 20
Wednesday 15

February Monday 20
Tuesday 20
Wednesday 10

Can i create a Getpivottable formula to pull the days listed under the month
of January? Anyone have ideas?

« Formatting for and adding thousandths of a second | how do i assign a value to a cell containing text »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pull in cell text to referrence sheet name in formula	dsweeney	Microsoft Excel Programming	3	1st Sep 2009 07:36 PM
Formula to pull first word from text string in a column	CrisT	Microsoft Excel Worksheet Functions	12	8th Jan 2009 08:13 PM
Formula numbers and text Trying to pull a random sampling	Not the expert	Microsoft Excel Worksheet Functions	1	7th Dec 2007 04:01 PM
Create formula that will pull a value based on text in diff cell?	=?Utf-8?B?U28gVHJ1IEdlbw==?=	Microsoft Excel Misc	0	22nd Jun 2006 08:16 PM
What function in a formula will pull the text used in a Tab name?	=?Utf-8?B?Q2hhcmxlcyBSb2RyaWd1ZXo=?=	Microsoft Excel Programming	4	5th Aug 2005 05:11 PM