Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GETPIVOTDATA on Excel 2000
Hi,
I have seen that you can use GETPIVOTDATA with more than one field on Excel 2003 and 2007. But is there any way of doing this with Excel 2000. I am currently using SUMPRODUCT to do a vlookup which has more than one variable. Is there another solution as this takes forever when the spreadsheet needs to recalculate. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
GETPIVOTDATA on Excel 2000
Yes, you can use multiple fields in an Excel 2000 GETPIVOTDATA formula.
For example, to see records for the Central region, for Truck sales, by salesperson Wilson: =GETPIVOTDATA($A$4,"Central Trucks Wilson") Louja wrote: Hi, I have seen that you can use GETPIVOTDATA with more than one field on Excel 2003 and 2007. But is there any way of doing this with Excel 2000. I am currently using SUMPRODUCT to do a vlookup which has more than one variable. Is there another solution as this takes forever when the spreadsheet needs to recalculate. -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA Excel 2000 | Excel Worksheet Functions | |||
GETPIVOTDATA....Excel 2000....Desperation! | Excel Worksheet Functions | |||
getpivotdata function with Excel 2000 | Excel Discussion (Misc queries) | |||
Getpivotdata - Excel 2000 vs. Excel 2002 and later | Excel Worksheet Functions | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions |