Check if value matches in a range

[suzeet]

Hi,
I want to match the column on a range. Suppose as in the example below, for the Sq No 1, if the Address column of first four rows (where Sq No = 1), I want to put a "YES" if matched, in the Match column

Sq No	ID	Address	Match
1	1500946	3410 WORTH ST <tbody> </tbody>	YES
1	1500946	3500 GASTON AVE <tbody> </tbody>
1	1500946	6401 MAPLE AVE APT 1203 <tbody> </tbody>
1	3312005 <tbody> </tbody>	3410 WORTH ST <tbody> </tbody>	YES
2	590851	3410 WORTH ST <tbody> </tbody>
2	590851	530 CLARA BARTON BLVD <tbody> </tbody>
2	590851 <tbody> </tbody>	TOPA <tbody> </tbody>
2	3312027 <tbody> </tbody>	3415 WORTH ST <tbody> </tbody>
3	1469183 <tbody> </tbody>	144 PINE MEADOWS LN <tbody> </tbody>	YES
3	3312034 <tbody> </tbody>	144 PINE MEADOWS LN <tbody> </tbody>	YES

<tbody>
</tbody>

 

[Special-K99]

How about this?

=IF(COUNTIFS(A$1:A$10,A1,C$1:C$10,C1)=2,"YES","")

Works fine on your sample data

BUT

make sure you test it on lots of other data as I'm not sure it's totally correct.

But it does work on your data.