Forum Discussion
How to create a pivot table over a range containing dynamic arrays?
I have my raw data in Column C. In Column E I have a dynamic array `=UNIQUE(C4:C9)`. Now, I would like to create a pivot table whose data source is this dynamic array in Column E. When the height...
You don't. Create the pivot table using the Raw data and it will automatically collect the unique data. Maybe you need to give the full picture.
UNIQUE formula is just an example of dynamic array formula. What I want to say is that the range holding a dynamic array formula may change because of the change of the value of the raw data.
And how to create a pivot table over this dynamic range?