stop increasing the num, when drag down the columns

[cmiaoqin]

Hi all,

I got this formula, n i want to drag down so that the rest of th
columns has this formula too. However, when i drag down. A12 become
A13. I want A12 to remain as A12 and A1 become A2 n so on n so for
Does anyone know how to do it?

=IF(COUNTIF($A$1:A12, A1)>1,"Duplicate","Unique"

 

[Ian]

See my response to your post $A$1.

 

[cmiaoqin]

Ian thanks alot u anwersed my question.