Help please.
Looking for a formula to define col D.
I want to know the latest known 'Value' from colC (where it is not 0, UNLESS there is no other value). Grouped by 'ID' (ColA), and ordered by date (ColB)
To get the latest date I can use "=IF(MAXIFS(B:B,A:A,A2)=B2,"Current","")", but I need...