use the AGGREGATE to return the row number of the match, and use that within an INDEX
edit: should have added, the above returns value relevant to Min date (given F19), for the Max equivalent change F19 to E19 (nothing else)Formula:
=INDEX(Table8[Column1],AGGREGATE(15,6,(ROW(Table8[Date])-ROW(Table8[#Headers]))/(Table8[Build]=$A19)/(Table8[Country]=$B19)/(Table8[type]=$C19)/(Table8[year]=$D19)/(Table8[Date]=$F19),1))
obviously, modify Column1 to be the relevant field in your table
Bookmarks