C
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"
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"