ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can i pull text with a Getpivottable formula? (https://www.excelbanter.com/excel-worksheet-functions/110076-can-i-pull-text-getpivottable-formula.html)

Jonathan

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?


All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com