Forum Discussion
Help with dynamic table
Hi
How to calculate, in the dynamic table itself, a column with the division of the results obtained in the table itself (example average/maximum)
How to calculate, in the dynamic table itself, a column with the division of the results obtained in the table itself (example average/maximum)
2 Replies
A little more description would be helpful. How exactly are you using the term "dynamic table," for example? Is it a standard Excel Table (which is dynamic in the sense that it can grow as new rows get added); or is it the result of one of the new Dynamic Array functions, FILTER, perhaps?
My initial assumption was that you're talking of the latter, and that could be tricky....so we may end up needing to look for a creative solution if this is something that you'll be needing to do repeatedly. But help us all get started by a little bit more expansive description of your situation, if not a copy of the actual spreadsheet.
