I have this worksheet:
IhaveinthespreadsheettheclientELISMARCARLOSRODRIGUESDAMATA,whomade3purchases,twoon10/08/2014andoneon20/08/2014.WhatIneedistoconsolidateallpaymentsonthesamedateonthesameline,ie,looklikethis:
The two installments on August 10, 2014 were added together (399 + 1561.56) and consolidated on a single line, and the one on 08/20/2014 remained normal, since it was another day.
I tried with dynamic spreadsheets, the best result I had was this:
It separates payments by DATA and groups the installments that have been paid by CPF. What already helps, though, is that I need the worksheet to be in the above pattern, to use in a code that is already ready.