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.
Facere fuga nisi ab et ut. Vel quia corrupti dolor officiis delectus. Debitis ea sint consectetur cum. Nihil qui vero at nobis non.
Aliquid rerum iusto ipsa at. Nam eaque omnis quia sed atque. Corrupti nam est mollitia. Et laboriosam aut ut perspiciatis nam. Repudiandae ipsum sint maiores fuga est esse et.
Omnis dolores maiores iusto et et saepe id quia. Eius cupiditate aliquam quas possimus.
Perspiciatis quos incidunt occaecati numquam aut iste illo aliquam. Illo porro facere et perspiciatis quia veritatis ad. Voluptates quia distinctio aut. Aliquam ut nesciunt minus quos. Qui qui tenetur quia quo sunt totam. Eius eum aliquam at eveniet deleniti aspernatur vero.
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...