You can use a custom formula in Data Validation
=COUNTIF(A:A,A1)=0
and then set the error message to "Already entered"
cheers
You can use a custom formula in Data Validation
=COUNTIF(A:A,A1)=0
and then set the error message to "Already entered"
cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks