Formula help- Show Duplicates

[Natalia]

Hi,

Usually I would use the countif formula to give me Dupes and no dupes, how can i get the formula to return Dupes for all 3 highlighted cells

Excel Workbook
	A	B
1	ISIN	Status
2	AU0000000015TYU	NO DUP
3	USD15445454YUYR	DUP
4	EU15478787454EKJ	NO DUP
5	USD15445454YUYR	DUP
6	BNWGOIWRABNH	NO DUP
7	USD15445454YUYR	NO DUP
Sheet1

 

[BrianMH]

You just need to fix the range you are looking at.

=If(Countif($A$2:$A$7,A2)>1,"DUP","NO DUP")

 

[Natalia]

Thanks