Check if number already are in the sheet

[Guest]

Hi
Can some one help me
I need a code where i can write a number
maybe in a inputbox then the code shall see if the number i write already
are in the row, if Not write the number in the activecell , and if the are
there
error by msgbox or something like that

Hope some one can help

 

[Guest]

You don't need a macro. You can use validation... Try this. Highlite column A
(A1 should be the active cell). Select Data|Format ->Custom and add this
formula

=COUNTIF(A:A, A1) =1

Now try adding values into column A. It should not allow duplicates...

 

[Guest]

Thanks

Alvin


"Jim Thomlinson" skrev:

You don't need a macro. You can use validation... Try this. Highlite column A
(A1 should be the active cell). Select Data|Format ->Custom and add this
formula

=COUNTIF(A:A, A1) =1

Now try adding values into column A. It should not allow duplicates...