SOLVED

# Find earliest date based off criteria/duplicates

Highlighted
Occasional Contributor

# 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!

5 Replies
Highlighted

# Re: Find earliest date based off criteria/duplicates

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.

Highlighted

# Re: Find earliest date based off criteria/duplicates

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))``

``=@SORT(FILTER(\$D\$2:\$D\$13,\$A\$2:\$A\$13=\$A2),,1)``
Highlighted

# Re: Find earliest date based off criteria/duplicates

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

Highlighted

# Re: Find earliest date based off criteria/duplicates

Thank you!
Highlighted
Best Response confirmed by alexandrabiorka (Occasional Contributor)
Solution

# Re: Find earliest date based off criteria/duplicates

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.