stop increasing the num, when drag down the columns

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

See my response to your post $A$1.

--
Ian
--
"cmiaoqin" <cmiaoqin.1znz1b_1133949009.7054@excelforum-nospam.com> wrote in
message news:cmiaoqin.1znz1b_1133949009.7054@excelforum-nospam.com...
>
> 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")
>
>
> --
> cmiaoqin
> ------------------------------------------------------------------------
> cmiaoqin's Profile:
> http://www.excelforum.com/member.php...o&userid=29430
> View this thread: http://www.excelforum.com/showthread...hreadid=491387
>

Ian thanks alot u anwersed my question.