Duplicate

  • Thread starter Thread starter David
  • Start date Start date
D

David

is there any way to restrict data entry in a cell
to "unique values" only
 
Select A1:A10 and Data>Validation>Allw>Custom and enter:
=COUNTIF($A$1:$A$10,A1)=1
and you'll see how it works.
 
You must log in or register to reply here.

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

Removing Duplicate Values 1
Highlighting duplicate cells in a column 2
Adv Filter - Unique Items NOT working 6
Calculating duplicates 2
Find duplicates in address register 2
Deleting Duplicated Data by Cell 2
Duplicates Deletion ? 2
Identifying duplicate rows 2

Back
Top