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
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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks