Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
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
using wildcard characters for filenames in externally linked files Harold Good Excel Discussion (Misc queries) 0 June 27th 06 03:40 AM
WildCard Characters Ralph Heidecke Excel Worksheet Functions 1 June 1st 06 07:43 PM
How do I use wildcard characters in Excel 2003 sumif formula? Erik T Excel Worksheet Functions 1 February 13th 06 08:41 PM
Formula to replace invalid filename characters tschultz Excel Worksheet Functions 2 January 27th 06 07:07 PM
Using Wildcard characters in sumproduct Charles Excel Worksheet Functions 3 July 22nd 05 05:23 AM


All times are GMT +1. The time now is 05:17 AM.

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

About Us

"It's about Microsoft Excel"