Prevent Repeating Data Entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Howdy,

I need a way to prevent a user from entering duplicate data in a range of
cells (ex. C6:C36). I need to prevent the user from entering an invoice
number twice. I don't know if this is something for Data Validation or not. I
have been trying that and cant get it to work.
 
Ryan,

Select C6:C36, the use Data / Validation... on the "Settings" tab, Select Custom under "Allow"
and use the formula

=COUNTIF($C$6:$C$36,C6)=1

HTH,
Bernie
MS Excel MVP
 
Thanks a lot, thats helped out alot

Bernie Deitrick said:
Ryan,

Select C6:C36, the use Data / Validation... on the "Settings" tab, Select Custom under "Allow"
and use the formula

=COUNTIF($C$6:$C$36,C6)=1

HTH,
Bernie
MS Excel MVP
Click to expand...
 
What If I already have validation Allow=List AND I want to detect duplicates
in range say H13:H20

Validation:
Allow: List
Source: =AccountList

John
 

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

Preventing Duplicate Records 2
Combobox filtering 2
Prevent duplicate entries within a range of cells from a drop-down 3
Prevent Duplicate Form Entries 0
get Data Validation to stop, list supplied, duplicate data entries 1
preventing data entry if one cell's value smaller then zero 5
Data validation on a custom format 3
How can I make this macro works 2

Back
Top