Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Data From a Pivot Table to autofill
How do I use data from a pivot table in a formula outside of the pivot table,
and autofill down? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Data From a Pivot Table to autofill
"barbb" wrote:
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 --- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Data From a Pivot Table to autofill
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. barbb wrote: How do I use data from a pivot table in a formula outside of the pivot table, and autofill down? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
How to set the autofill options in a column of a input data table | Excel Discussion (Misc queries) | |||
Is there an autofill for all row fields in a pivot table? | Excel Worksheet Functions |