Find earliest date based off criteria/duplicates

[alexandrabiorka]

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! 

[#2]

@alexandrabiorka 

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.

[#3]

@alexandrabiorka 

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)

[#4]

@Subodh_Tiwari_sktneer - thank you so much! That worked great for me.

[#5]

Thank you!

[#6 · Accepted solution]

@alexandrabiorka 

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.