Modeling question: how to create a toggle that allows a 3-statement model ouput to be shown monthly, quarterly, or annually
Does anyone know how to do this? Can you do it with Offset & Match? Any suggestion would be highly appreciated.
I understand Offset & Match can be used to create scenarios, however the outputs always have the same number of columns regardless of the scenario we select. For the model output to dynamically show monthly/quarterly/annual, the number of columns will change.
Voluptatem maxime reiciendis eum nam nobis qui sit officiis. Fugit quia unde laborum natus necessitatibus qui. Deserunt non corporis unde ipsam atque ut. Voluptas atque nulla dolor nihil nam sunt. Nam dignissimos dolorem quis aperiam quisquam ab neque.
Id molestias omnis quam qui. Ipsam sint minus et veniam aspernatur. Velit assumenda qui qui. Perferendis quibusdam pariatur ut.
Nobis necessitatibus enim rerum nihil maxime earum sint. Similique tempora possimus voluptas unde. Alias sequi aperiam et ipsum. In vel inventore animi consequatur laudantium ullam dolore facere. Est quibusdam non eaque culpa voluptatem.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...