Into C2 enter the formula
Code:
=IF(COUNTIFS($A$2:$A$39,$A2,$B$2:$B$39,"APP G")>0,"Y","N")
and copy down. It returns "Y" whenever "APP G" is the type for group at least once.
Code:
=IF(COUNTIFS($A$2:$A2,$A2,$B$2:$B$2,"APP G")>0,"Y","N")
copied down returns "Y" starting from 1st occurrence of type "APP G" for given group (i.e. when at start the group number is not of type "APP G", but later will have this type, then the formula returns "Y" only for records startibg from the one of type "APP G").