need help w/ data validation problem
Posted by Kevin on October 02, 2001 11:50 AM
We have a spreadsheet file at work in Excel 2000, that contains a column with serial numbers. We have data validation turned on in that column to only allow a number to be entered once. If you try to enter a duplicate number, you get an error message. The problem is that every once in a while, we will run into a situation where we type a number in and get the message that this is a duplicate and prompts us to change the number to something else, but when we do a search to try and find the number, there is no such number in the spreadsheet. Does anyone know why it is telling us that the number is a duplicate if it is the only number of its kind in the sheet?
Thanks in advance,