D E F
06/30/2018 I 1
06/30/2018 I 1
06/30/2018 C 2
06/30/2018 I 1
06/30/2018 I 1
Third column formula
=IF(AND(YEAR(D23)=2018,E23=“I”),“1”,)&IF(AND(YEAR(D23)=2018,E23=“C”),“2”,)&IF(AND(YEAR(D23)=2018,E23=“H”),“1”,)&IF(AND(YEAR(D23)=2018,E23=“Life”),“1”,)
I’m a rookie so be gentle