The former did not work for me :-(
... to star twith.

But now I know way

Every time a treed a formula with , (Comma) I had problem€¦
Now I use ; (semicolon) and everything thing works. :-)

Probably I dont use €œstandard€� Regional and Language Options for Windows

Thankt for the formula.

LO in Sweden




"Mike H" skrev:

Have a look he-

http://www.cpearson.com/excel/Duplicates.aspx

Mike

"LO in Sweden" wrote:

Hello!

I have around 2000 articel nr. in a column (A) and add new sometimes.
Then I add new I wish to check so I dont get any duplicate.

Can I do that easy?

Thanks
LO in Sweden