Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello,
I have 4 seperate columns in one worksheet which I have create seperate pivot tabels for, I would like the columns corresponding to the pivot table to be dynamic. Do I make seperate Name for each set of data like below or can I make one Name capturing all the data. Need one for Customer, Parts, Priority also. Name: 'CCFeedback'!TableData Refers To: =OFFSET(CCFeedback1!$B$3,0,0,COUNTA(CCFeedback!$A: $A),1) Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can you use multiple ranges in a function? | Excel Worksheet Functions | |||
Dynamic Named Ranges | Excel Discussion (Misc queries) | |||
rank/small with multiple ranges | Excel Discussion (Misc queries) | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel |