I tried again with a new worksheet and it worked fine but still doesn't work
on the first one. I cleared all and I did it again. I don't know what is
wrong?

"Mary" wrote:

Hi,
I am trying to set up column D as unique but everytime that I type the below
formula doesn't work. If I enter the same value twice it takes.
=COUNTIF(D:D,D1)<2