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

Dear all, i hope somene can help - because ive just pulled out my last hair
i'll tryto explain - in column A i have a list of 30 names (which may be
duplicated in some places) - in column B i have two possible entries against
each name "OK" or "DI"

What i would like to do is have a formula that would count the name and the
number of "OK" and "DI" together
I could then on a seperate sheet have the one name and the total of OK and
DI against the name

simple for some of u - but not for me - sorry

Regards

Andy the novice