Using Data From a Pivot Table to autofill

  • Thread starter Thread starter barbb
  • Start date Start date
B

barbb

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

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
---
 
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.
 
Back
Top