I have the following data sheet. It has a row of dates, where every date has an A
and a B
value. I would like to find the last filled-in B
value for that range.
In the following screenshot, I would like a formula which can calculate the contents of the LAST A
column for every row.
Please note I do not want to merely find the last filled-in cell. For row 5
that would be C5
, while the last B
-value would be B5
, or 6.
=AGGREGATE(14,3,A1:A5*(A1:A5>0),1)
do not work in LibreOffice. However=SUMPRODUCT(A1:A5>1)
works.