CODEWITHSUNDEEP
excelexcel-formula
Samantha Klonaris
Samantha Klonaris

Reputation: 75

Formula to get most recent value for distinct ids in excel

I'm new to Index and Match functions. I'm looking to get the most recent value for each id. The dates are not sorted. I'm trying to come up with a formula for the "Expected Values" column

enter image description here

Upvotes: 0

Views: 482

Answers (1)

BigBen
BigBen

Reputation: 50162

One option:

=SUMIFS(C:C,A:A,E2,B:B,MAXIFS(B:B,A:A,E2))

enter image description here

Upvotes: 0

Related Questions