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.
Atque ducimus asperiores odio labore optio. Consequatur omnis non deleniti qui impedit assumenda. Laboriosam fugiat deleniti nesciunt. Aut deleniti eius distinctio aperiam ut.
Quis illo autem qui explicabo expedita quia nostrum. Rerum explicabo architecto ea fuga quia et ipsam. Veniam aut necessitatibus hic sint et ipsam.
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...