Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to prevent double entry in excel?
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 |
#2
|
|||
|
|||
See this site George
http://www.cpearson.com/excel/NoDupEntry.htm -- Regards Ron de Bruin http://www.rondebruin.nl "George Teng" <George wrote in message ... 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 |
#3
|
|||
|
|||
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 DataValidation 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 -----Original Message----- 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 . |
#4
|
|||
|
|||
You can also read this :
http://support.microsoft.com/default...b;en-us;213185 "Ron de Bruin" wrote: See this site George http://www.cpearson.com/excel/NoDupEntry.htm -- Regards Ron de Bruin http://www.rondebruin.nl "George Teng" <George wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Data validation to prevent duplicate entry. | Excel Discussion (Misc queries) | |||
prevent duplicate entry for range of numbers 00001 to 99999 in ex. | Excel Discussion (Misc queries) | |||
data entry in Excel slow | Excel Discussion (Misc queries) | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel |