On the same sheet, in F1 :
=A1
in F2:Fn (drag down as far as needed) :
=IF(ISERR(SMALL(IF(ISNA(MATCH($A$1:$A$30,$F$1:F1,0 )),ROW($1:$30)),1)),"",INDEX($A$1:$A$30,SMALL(IF(I SNA(MATCH($A$1:$A$30,$F$1:F1,0)),ROW($1:$30)),1)))
(Array formula, validate with Ctrl+Shift+Enter)
in G1 :
=SUMPRODUCT(($A$1:$A$30=F1)*($B$1:$B$30="OK"))
in H1 :
=SUMPRODUCT(($A$1:$A$30=F1)*($B$1:$B$30="DI"))
drag down as far as needed.
HTH
Daniel


On the same sheet, in F1 :
=A1
in F2 :
=IF(ISERR(SMALL(IF(ISNA(MATCH($A$1:$A$30,$F$1:F1,0 )),ROW($1:$30)),1)),"",INDEX($A$1:$A$30,SMALL(IF(I SNA(MATCH($A$1:$A$30,$F$1:F1,0)),ROW($1:$30)),1)))
(Array formula, validate with Ctrl+Shift+Enter)
in G1 :
=SUMPRODUCT(($A$1:$A$30=F1)*($B$1:$B$30="OK"))
in H1 :
=SUMPRODUCT(($A$1:$A$30=F1)*($B$1:$B$30="DI"))
HTH
Daniel