There is a function that you enter into data validation that keeps users from entering the same thing in twice in a whole column. I think it actually checks for the cells value to equal/1/True to another value that is the same and throws the error message. I lost the code I had. Anyone know of this? I pulled it from excel bible 2007 book a while ago...
It actually is a very helpful tool for data duplication.
Thanks.
Bookmarks