Quote:
Originally Posted by ArviLaanemets
Into C2 enter formula like
Code:
=IF(AND(OR($A2=$A1,$A2=$A3),OR(COUNTIFS($A$2:$A$10,$A2,$B$2:$B$10,1)>0,COUNTIFS($A$2:$A$10,$A2,$B$2:$B$10,2)>0)),"Y","")
, and copy down. |
Thank you Arvi. In my several attempts to write the code before I threw down the towel and sought this forum's help, I used the IF, AND, OR and COUNTIFS but combining them into one logical formula was really beyond me.