How to prevent double entry in excel?

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

Guest

Hi,

I'm trying to avoid double entry in this particular work here. Is there any
formulas or function that allow me to automatically detect the double entry?

George
 
Hi!

You can use Data Validation to do this.

Assume you'll be entering data in the range A1:A100 and
want to prevent any duplicate entries.

Select the range A1:A100
Goto Data>Validation
From the Allow drop down select Custom
In the Formula box enter:

=COUNTIF($A$1:$A$100,$A1)<=1

If you want, you can create a custom message that will pop
up if a duplicate entry is attempted.

Click the Error Alert tab.

Use a message something like this:

You are attempting to make an entry that already exsists!

Click OK and you're all set!

Biff
 
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

I donot want to make double entry in excel sheet? 3
double-clicking a list entry 2
How do I prevent text entering? 2
Duplicate Entries 3
Access Click in Table to Open Form 0
list double entries 1
Remove double data entries 2
Adding double quotes around entries in a column 5

Back
Top