Mar 15 2022 08:09 AM - edited Mar 15 2022 09:42 AM
solved thanks so much!
I have an attachment for the actual workbook, but it doesn't seem to be working for some reason....
Thank you so much!
Mar 15 2022 08:51 AM
Mar 15 2022 09:02 AM
SolutionIn E2:
=LET(yes,MINIFS($B$2:$B$31,$A$2:$A$31,A2,$D$2:$D$31,"Yes"),no,MINIFS($B$2:$B$31,$A$2:$A$31,A2,$D$2:$D$31,"No"),IF(OR(no=0,AND(yes>0,yes<no)),"Yes","No"))
Fill down.
Mar 15 2022 09:03 AM
Mar 15 2022 09:05 AM - edited Mar 15 2022 09:05 AM
you are a genius! thanks so much
Mar 15 2022 09:02 AM
SolutionIn E2:
=LET(yes,MINIFS($B$2:$B$31,$A$2:$A$31,A2,$D$2:$D$31,"Yes"),no,MINIFS($B$2:$B$31,$A$2:$A$31,A2,$D$2:$D$31,"No"),IF(OR(no=0,AND(yes>0,yes<no)),"Yes","No"))
Fill down.