• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Reconcile quarterly and annual schedule

DAGUET

Member
hello

I currently try to reconcile in a same worksheet a quarterly schedule of cash payments to shareholders and a yearly (annual accounting figures derived from the income statement of a company).

The idea is simple : end of period Dec 31st should coincide and be aligned with December in the cash statements (except that in between, I have march, june, september..., 3 quarters for which I could insert 3 empty columns).

My modeling horizon goes to 2035 and therefore I need an automated process which allows me to keep the formulae intact.

Transpose can' t do the job nor is suited for it.

Any idea to rationalize the solution is welcome!!!!
*
Best Regards
 
@DAGUET,

Please remove your personal info from your signature. Please post a sample file, it will be easier for others to respond.
 
Please put this formula in some cell and drag to right, see if it works.

=SUMPRODUCT((YEAR($E$12:$AU$12)=YEAR(E4+1))*($E$13:$AU$13))
 
Back
Top