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.
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.