| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Index & Match on Pivot Table
Hi,
I'm using Office 97 - and was wondering if there is a way to do an Index (Match), (Match) type function on a Pivot Table? I've tried it - but I get a #value error. Does anyone know a way around this? Nelson |
|
#2
|
|||
|
|||
|
Nelson wrote: Hi, I'm using Office 97 - and was wondering if there is a way to do an Index (Match), (Match) type function on a Pivot Table? I've tried it - but I get a #value error. Does anyone know a way around this? Nelson -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
|
|||
|
|||
|
You can use the GETPIVOTDATA function to extract data from the pivot
table. For example: =GETPIVOTDATA($A$5,"Ontario") Look in Excel's Help for examples. Nelson wrote: Hi, I'm using Office 97 - and was wondering if there is a way to do an Index (Match), (Match) type function on a Pivot Table? I've tried it - but I get a #value error. Does anyone know a way around this? Nelson -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| pivot table | Excel Worksheet Functions | |||
| Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
| Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
Linear Mode
