Split Amount into Monthly Columns

Download File: https://www.excel-university.com/yt_h-hplwwhj0q/

Let's say you need to take an amount and split it evenly into monthly columns. For example, perhaps you need to recognize revenue you collect up front over time. Or, perhaps you have spent some money and you need to allocate the expense over time. There are other illustrations, but the basic idea is that you have a total amount that you need to spread evenly into monthly columns. As this is Excel, there are many possible approaches. In this post, I'll present a solution that uses dynamic arrays. The benefit of this solution is that you can quickly and easily adjust the number of columns displayed in the report.

Тэги:

#Excel_University #Jeff_Lenning

Скачать видео