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


[TABLE="width: 272"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]INV No.[/TD]
[TD]Text[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD="align: right"]27[/TD]
[TD]AA[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD="align: right"]27[/TD]
[TD]BB[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD]BB[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD="align: right"]28[/TD]
[TD]BB[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD]BB[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD="align: right"]29[/TD]
[TD]BB[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD="align: right"]299[/TD]
[TD]AA[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]

 

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