find if vendors are oprating in multiple regions/countries/etc...

[ulooz]

Hi, i'm looking to find if vendors are oprating in multiple regions/countries/etc... should be very simple but i'm having a brain fart... example below. so ideally i'd have a formula, for example, to flag Vendor A as "YES" and vendor B as "NO".

Vendor	Region	Sales
A	AMER	100,000
A	EMEA	50,000
A	APAC	75,000
B	APAC	25,00
C	AMER	45,000
D	AMER	20,000
D	EMEA	70,000

 

[hagia_sofia]

Provided that there are no duplicate records within a vendor, then e.g.

=IF(COUNTIFS(A2:A8,A2:A8)>1,"YES","NO")

 

[ulooz]

Provided that there are no duplicate records within a vendor, then e.g.

=IF(COUNTIFS(A2:A8,A2:A8)>1,"YES","NO")

Thank you. Why is the critera range same as the criteria? and I may have oversimplified the table, because Vendor B can be listed hundreds of time, each time there is an entry. would this necessarily return a yes value?

 

[MARZIOTULLIO]

Book1
	A	B	C	D
1	Vendor	Region	Sales
2	A	EMEA	100,000	YES
3	A	EMEA	50,000	YES
4	A	PIO	75,000	YES
5	B	APAC	25,00	NO
6	C	AMER	45,000	NO
7	D	AMER	20,000	YES
8	D	EMEA	70,000	YES
9
Sheet1

Cell Formulas
Range	Formula
D2:D9	D2	=IFERROR(IF(ROWS(UNIQUE(FILTER($B$2:$B$100,($A$2:$A$100=A2)*($A$2:$A$100<>""))))>1,"YES","NO"),"")

Copy down