Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot tables & Dynamic Ranges?
Hi,
Does anyone know if pivot tables can be based on dynamic ranges (defined with OFFEST/COUNTA)? as I've tried but can't seem to get it to work. Many thanks, Jason |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot tables & Dynamic Ranges?
Yes, it's possible. Make sure that when creating the range you use absolute
references like =OFFSET($A$1,0,0,COUNTA($A:$A),COUNTA($1:$1)) or something similar., give it a name (MyRange) and click add. Then, in PivotTable wizard, when you get to screen asking for range of cells, type the name of your range (no equal sign) MyRange Note that you still need to update the pivot table for changes to take effect. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Me!" wrote: Hi, Does anyone know if pivot tables can be based on dynamic ranges (defined with OFFEST/COUNTA)? as I've tried but can't seem to get it to work. Many thanks, Jason |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot tables & Dynamic Ranges?
Hi,
To make a range dynamic, you may convert it from a range to a list 9Ctrl+L) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Me!" wrote in message ... Hi, Does anyone know if pivot tables can be based on dynamic ranges (defined with OFFEST/COUNTA)? as I've tried but can't seem to get it to work. Many thanks, Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining pivot tables, then making a ranges. | Excel Discussion (Misc queries) | |||
Pivot Tables with Multiple ranges | Excel Discussion (Misc queries) | |||
Multiple Consolidation Ranges in pivot tables | Excel Worksheet Functions | |||
Pivot tables and dynamic columns | Charts and Charting in Excel | |||
Dynamic Pivot tables | Excel Discussion (Misc queries) |