View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jonathan Jonathan is offline
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?