How to lookup duplicate Values

[SunnyAlv]

can u help me please

how to Lookup Duplikat Values in excel using Formula

Please Help Me

 

[Georgiboy]

One method:

Book1
	A	B
1	TRIGGER	Result
2	UNIP123	TRUE
3	UNIP123	FALSE
4	HPM567	TRUE
5	HPM567	FALSE
6	AHM567	TRUE
7	DPM890	TRUE
8	DPM890	FALSE
Sheet1

Cell Formulas
Range	Formula
B2:B8	B2	=COUNTIF(A$2:A2,A2)=1

 

[SunnyAlv]

One method:

Book1
	A	B
1	TRIGGER	Result
2	UNIP123	TRUE
3	UNIP123	FALSE
4	HPM567	TRUE
5	HPM567	FALSE
6	AHM567	TRUE
7	DPM890	TRUE
8	DPM890	FALSE
Sheet1

Cell Formulas
Range	Formula
B2:B8	B2	=COUNTIF(A$2:A2,A2)=1

please answer the "Size" column not "Result" column

 

[Georgiboy]

It would be the same formula but instead of the letter 'A' in the formula it will be whatever column the 'Size' header is in.

I only have a picture without headings to look at so i don't know where thngs are on the worksheet.