May 06 2020 07:31 AM
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!
May 06 2020 11:57 AM
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.
May 06 2020 12:09 PM
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)
May 06 2020 12:19 PM
@Subodh_Tiwari_sktneer - thank you so much! That worked great for me.
May 06 2020 12:34 PM
Solution
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.
May 06 2020 12:34 PM
Solution
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.