Need some help with formula
I am Sylvain. I work in a french confectionnery. Not the unicorn candy company 🙂
I am building a cash flow monitoring and I have to import the bank book in a data module :
Only one line item is list formated : "compte"
Other are text, number or date
And the trouble is about the date. i have to take the data from the row "'dat.point".
But i only have the date on 1line by accounting entry (row "piece")
How can i complete the empty cell with the date? The date is always on the last line, like on the screenshot.
i was thinking about making a list with "Piece" but it's maybe overkill
or maybe using ISFIRSTOCCURRENCE ?
thx a lot!