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
---