Index min value from one column based on multiple matches in another column

[freeb1893]

I have an array with multiple records with the same name on them, but with different dates in another column.

I'd like to search that array, matching on the name, and index the farthest in the past date associated to the name

Here is some same data:

10/5/22 8:27 AM​	Smith, John
9/26/22 3:31 PM​	Doe, Jane
7/29/22 9:39 AM​	Gathering Requirements
7/29/22 9:39 AM​	Smith, John
11/8/22 2:15 PM​	Rickman, Alan
7/18/22 4:52 PM​	Ready for Code Review
7/29/22 9:11 AM​	Ready for Code Review

The resulting formula, if I looked up "Smith, John", I'd return 7/29/22 9:39 AM since it's the farthest in the past date associated to a record under his name

Anyone know how to put this into a formula? Thanks in advance

 

[SunnyAlv]

idk this formula can help u or not, but i recomended this formula to help ur problem

u can see at picture below

=IFERROR(INDEX($L$4:$L$13,AGGREGATE(15,6,(ROW($L$4:$L$13)-MIN(ROW($L$4:$L$13))+1)/($M$4:$M$13=$P$4),ROW(A1))),"")

 

[Anonymous1378]

Try =MINIFS(DateTimeColumn,NameColumn,Name)?