Forum Discussion
Dynamic Table and Functions
Hey guys! So I have a master sheet of Portfolio Losses of each Month. I want to create a sort of dynamic table and input system in which the user can enter the start month and the end month and a...
That's job for Dynamic Arrays but they don't support in Excel 2019. In it that could be Power Query and/or VBA solution or bunch of legacy formulas which will keep cells empty for non-filtered data.
In any case small sample to illustrate the question is quite desirable. We don't need your actual file, if someone suggests the pattern you may modify it and apply to your actual data.