Hi all,

I got this formula, n i want to drag down so that the rest of the columns has this formula too. However, when i drag down. A12 becomes 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")