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...
Why would you want the same data set that grows in one sheet? Your Eye can only look at one set of information at a time and the idea of a pivot table is to do analysis to the raw data set meaning if you're going to analyze the raw data set it would be unlikely that you would be working on adding new data to the data set. So why would you want both in the same sheet?