A recent question from a CPA in Canberra allowed me to combine the MOD function and helper cells to offer a solution. The image below is the structure that we needed to populate. The entries are keyed in, but we need to automate the allocation with a formula. You can download an example file at … Continue reading Allocating Across Financial Years