Using Data From a Pivot Table to autofill


B

barbb

How do I use data from a pivot table in a formula outside of the pivot table,
and autofill down?
 
Ad

Advertisements

M

Max

barbb said:
How do I use data from a pivot table
in a formula outside of the pivot table, and autofill down?

Maybe a quick example to illustrate ..

Assume the 1st col of the pivot snippet below
is what you want to autofill in an empty adjacent col to the right
(outside of the pivot)

In A3:A10 is:
-----
Count of Dat3 (< in A3)
Dat1
A


B

Grand Total (< in A10)
------------

Put in G5: =A5
Put in G6: =IF(A6="",G5,A6)
Copy G6 down to G9

This will return the "fill from above" results that you want:
A
A
A
B
B

which could then be used as the match col for downstream index/match
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---
 
Ad

Advertisements

D

Debra Dalgleish

In Excel 2002 and later versions, a GETPIVOTDATA formula is
automatically created when you link to a cell in a pivot table. There
are instructions here for adding the Generate GetPivotData button to a
toolbar, and toggling that feature on and off:

http://www.contextures.com/xlPivot06.html

When it's turned off, you'll create a normal reference when you click on
a cell in the pivot table. Then you'll be able to copy across or down.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top