Forum Discussion
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 Column C. How would I do that? Thanks!
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.
5 Replies
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!
If you have Office 2019 or 365, you may use MINIFS function like this...
=MINIFS($D$2:$D$13,$A$2:$A$13,A2)If that is not the case, you may try the following Array Formula which requires confirmation with Ctrl+Shift+Enter instead of Enter alone
=MIN(IF($A$2:$A$13=A2,$D$2:$D$13))Refer to the attached for more details.
Subodh_Tiwari_sktneer - thank you so much! That worked great for me.
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.
