Excel validation for unique entry

K

Keith Davis

How can I use the validation function of Excel to
restrict the entry of data in a given column to values
that are unique? That is, if a value '48' has already
been entered, then 48 can not be reentered further down
the column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
RTD server : Updatenotify does not return and Excel not calling refreshData method 2
Split form 0
get Data Validation to stop, list supplied, duplicate data entries 1
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Data Validation List (conditional) 2
A data validation question 1
Duplicate entry in a column/row 14

Top