ETAF Active Member Mar 14, 2023 #2 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, "") abc1TRUE1abc2FALSEabc3FALSExyz2TRUE2abc4FALSE1FALSE Attachments min-etaf.xlsx 9.2 KB · Views: 3
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, "") abc1TRUE1abc2FALSEabc3FALSExyz2TRUE2abc4FALSE1FALSE
S santhoshkunder Member Mar 14, 2023 #3 ETAF said: 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, "") abc1TRUE1abc2FALSEabc3FALSExyz2TRUE2abc4FALSE1FALSE Click to expand... Thanks. Works a treat!
ETAF said: 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, "") abc1TRUE1abc2FALSEabc3FALSExyz2TRUE2abc4FALSE1FALSE Click to expand... Thanks. Works a treat!
