How do I look up earliest date value?

Question

I have data that tracks the history of the value of a field. The columns are ParentId, FieldName, Date, Value.

I want to find the first value, the value with the earliest date, with a given set of ParentId and Field Names.

How do I do that? Thanks.

sergeibaklan · Answer

Ben898&nbsp;
If your records are sorted from Oldest to Newest by Date when INDEX (XMATCH(... could return the right value.

oliverscheurich · Answer

Ben898&nbsp;=INDEX($D$2:$D$11,MATCH(SMALL(IF(($A$2:$A$11=F2)*($B$2:$B$11=G2),$C$2:$C$11),1),$C$2:$C$11,0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.&nbsp;

detlef_lewin · Answer

Ben898&nbsp;Try MINIFS().&nbsp;

Forum Discussion

How do I look up earliest date value?

Share

Resources