Forum Discussion
Ben898
Aug 14, 2023Copper Contributor
How do I look up earliest date value?
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...
OliverScheurich
Aug 14, 2023Gold Contributor
=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.