• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Minimum by group with formulas

a sample would be better than an image

MINIFS() may work - depends on what the date is like

but
=MINIFS($C$2:$C$6,$A$2:$A$6,A2)=C2
with an IF ()

IF( MINIFS($C$2:$C$6,$A$2:$A$6,A2)=C2 , C2, "")


abc
1​
TRUE​
1​
abc
2​
FALSE​
abc
3​
FALSE​
xyz
2​
TRUE​
2​
abc
4​
FALSE​
1​
FALSE​
 

Attachments

  • min-etaf.xlsx
    9.2 KB · Views: 1
a sample would be better than an image

MINIFS() may work - depends on what the date is like

but
=MINIFS($C$2:$C$6,$A$2:$A$6,A2)=C2
with an IF ()

IF( MINIFS($C$2:$C$6,$A$2:$A$6,A2)=C2 , C2, "")


abc
1​
TRUE​
1​
abc
2​
FALSE​
abc
3​
FALSE​
xyz
2​
TRUE​
2​
abc
4​
FALSE​
1​
FALSE​
Thanks. Works a treat!
 
Back
Top