Formula to Match Text and update for same values in the row

[sur]

Hello Team,

Need to look for "AA" in the Text and if so update the Yes in result , for those multiple invoices if the Text is also not equal to "AA".

i have trying with below formula, but stuck:

=IF(AD16="AA","Yes",IF(MATCH(J16,$J$16:$J$22,0),"Yes","No"))

INV No.	Text	Result
27	AA	Yes
27	BB	Yes
28	BB	No
28	BB	No
29	BB	Yes
29	BB	Yes
299	AA	Yes

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[Fluff]

In your example why are the 28,BB rows flagged as "No", but the next 2rows are flagged "Yes"?

 

[Marcelo Branco]

I'm assuming 299 is a typo (should be 29). If i'm right try...

Formula in C2 copied down
=IF(COUNTIFS(A:A,A2,B:B,"AA"),"Yes","No")

M.