InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Would You Provide A Dynamic Range In "data Source" Of Pivot Tables In Ms Excel? |
|
Answer» To provide a DYNAMIC range in “Data Source” of Pivot tables, first create a named range using OFFSET function and BASE the pivot table using a named range created in the first STEP. To provide a dynamic range in “Data Source” of Pivot tables, first create a named range using offset function and base the pivot table using a named range created in the first step. |
|