Need formula help with IF statement

[richleeb2]

I want to enter"Yes" to the column Match if a Form has more than one row for the same State.  For example, Form A has 2 rows for NY, so it is marked Yes.  What is a good formula for this?

State	Form	Match
NY	A	Yes
NY	A	Yes
CA	B	No
PA	C	Yes
PA	C	Yes
NJ	D	No

[Robin_McIntosh · Accepted solution]

@richleeb2 - Here's one way of doing it.  I changed/added some of the initial data to show more detail.

[BS_THE_ANALYST]

@richleeb2 one way: