Forum Discussion
Return Value Based on Latest Date
Hello, I'm trying to return a value based on the latest date which has duplicates For example... Date Balance 01/01/24 £100 02/01/24 £120 01/02/24 £200 01/03/24 £210 01/03/24...
djclements I would like it to include dates that only appear once also
Adam08320 Unfortunately, it's not very clear what you're asking (even less so now). Are you just trying to return the last value in the Balance column? So, if Date was in column A and Balance was in column B, would any of the following do what you what?
=INDEX(FILTER(B:B, NOT(ISBLANK(A:A))), COUNTA(A:A))
=INDEX(B:B, XMATCH(, A:A) - 1)
=XLOOKUP(MAX(A:A), A:A, B:B,,, -1)
