How to label a row within a grouping

[wheddingsjr]

Hi all

I am working on a spreadsheet with 25k+ lines and need to identify whether a grouping has a certain "type" within the group (see attached). What I would like to do is go through the list and in column 'C' designate whether or not the type ' APP G' is in the group. If it isall the other lines within the group should have the letter 'Y' and if it doesnt the letter 'N'. Any assistance would be greatly appreciated.

Thanks

[jeffreybrown]

Give this a try based on the sample you provided...

=IF(A1=A2,C1,IF(ISNUMBER(SEARCH("APP G",B2)),"Y","N"))

[wheddingsjr]

Thanks JeffreyBrown..that worked perfectly!!!

[wheddingsjr]

Hi JeffreyBrown...Looks like I spoke too soon. The formula did work for the example that I attached but as it went further down the spreadsheet it stopped working. It is pulling the 'Y' or "NO' from the previous set and sometimes its incorrect. Any suggestions?

[jeffreybrown]

Are you saying it did not work with the example you posted or with different data?

If you're speaking of different data, I need to see the different data.

[ArviLaanemets]

Into C2 enter the formula

=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.

=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").