Forum Discussion
Solved
Find earliest date based off criteria/duplicates
Hi, I'm looking to find the earliest date (Due date, Column D) for each account (Column A). For example, I'd like to pull the earliest Due Date for "Deer" which would be 4/22/20 and pull it into Colu...
You're welcome! Glad it worked as desired.
Please take a minute to accept the post with the proposed solution as the Best Response/Answer to mark your question as Solved.
In addition,
variant which works practically on any version
=INDEX($D:$D,AGGREGATE(15,6,1/($A$2:$A$13=$A2)*ROW($A$2:$A$13),1))and variant which works only on recent versions
=@SORT(FILTER($D$2:$D$13,$A$2:$A$13=$A2),,1)- Thank you!
