check group status

hello!

I have a text file (or EXCEL file) of the below format:

1223{TAB}GSDF{TAB}OK
1223{TAB}GSDG{TAB}OK
1436{TAB}DFBB{TAB}OK
1436{TAB}CBDF{TAB}NOT OK
1436{TAB}TREG{TAB}OK
etc

I want to check which group (eg 1223, 1436) is OK or NOT OK
If in a group, there is a single NOT OK, then the whole group is NOT OK. Else, it's OK (ie if all group lines are OK).

please note that in the source text, the group entries will always be together (ie there will not be a 1436 line between two 1223 lines, etc), but I may add more columns (however the group column will always be the first and the status (OK or NOT OK) the last)

thanks!