I have prevented duplicate entries in a column containing numbers using data validation. when trying to enter a number which does not exist in the said column, error message displays and entry is prevented. Please help
.