Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 138
Default Can i pull text with a Getpivottable formula?

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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Invisable text in formula bar Leroy-P Excel Discussion (Misc queries) 2 December 8th 05 02:40 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
Formula Being treated as Text BBB Excel Worksheet Functions 2 September 20th 05 05:38 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
Using the text from a cell as a range name in a formula Fletch Excel Discussion (Misc queries) 3 June 13th 05 07:57 PM


All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"