View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bbddvv
 
Posts: n/a
Default HELP: Wildcard Characters

In the following GETPIVOTDATA function, what wildcard characters can i
replace the "?????" in the below equation to cover all "Regions"?

=GETPIVOTDATA("Sales",A4,"Region", ????? ,"Company","Brooks Inc")

My PivotTable looks like this
Column 1: Region
Column 2: Company
Columns 3-10: various data

Thanks in advance,
Brad