0
I have this spreadsheet:
I have in the spreadsheet the client ELISMAR CARLOS RODRIGUES DA MATA, who made 3 purchases, two on the date 10/08/2014 and one on the date 20/08/2014. What I need is to consolidate all payments of the same date on the same line, ie stay like this:
The two installments of the day 10/08/2014 were added (399 + 1561,56) and consolidated in one line and the day 20/08/2014 remained normal, because it is another day.
I tried with dynamic spreadsheets, the best result I had was this:
It separates the payments by DATE and groups the installments that were paid by CPF. What already helps, however, I need the spreadsheet to be in the above standard, to use in a code that is already ready.
Have you developed anything? post your code or your formula to try to help you.
– LucasMotta
I haven’t developed anything yet. I couldn’t find a solution.
– guilherme
I’m reinstalling the office here, as soon as I can I’ll be trying. But try to do something
– LucasMotta
Dynamic table ... no need to put your hand on a code line ...
– gmsantos
But how do I put the dynamic spreadsheet in the pattern that is there? and use in my code?
– guilherme
use in which code ? there is no code in your question
– gmsantos
I know, I want to use this spreadsheet in a code, the code is already ready, I just need the spreadsheet in standard format.
– guilherme
But then make the hand...
– LucasMotta
this is just a piece of the spreadsheet, it’s over 10,000 records.
– guilherme