ALERT IF TRY TO ENTER SAME SECOND TIME

  • Thread starter Thread starter dancer
  • Start date Start date
D

dancer

I need to enter data in about 10 columns from hard copies I get daily. One
of these columns will be a key (alphanumeric) that defines a job. I may
receive other hard copies on other days of that same job. I don't want to
enter the data a second time. How can I have the sheet alert me if I try
to enter the key again?
 
You can data validation for this.

Suppose the range in question is A1:A10

Select the range A1:A10
Goto the menu Data>Validation
Allow: Custom
Formula:

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

Ok

Whenever you attempt to *manually* enter a duplicate value a message box
will pop up and alert you. This can be defeated by copying/pasting and/or
drag/drop.

Biff
 
WONDERFUL! Now, please explain the formula. I just can't understand how
it works.

Thanks
 
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

Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Excel Help to copy information from one row at a time to another sheet 1
Help Needed ... Probably simple for you gurus ... locking cell afterdata entered and 1
Show other cell if blank 5
How to enter start and end date/time in excel based on some specific value. 7
Problem with VLookup..... 1
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
countif in Data Validation stops working? 3

Back
Top