Greetings to you from GLOBALedge.
Please find attached a excel worksheet which describes using COUNTIF function to avoid duplicate entries. This worksheet also uses the DATA VALIDATION option in Excel.
Note: Please enable MACROS while opening this worksheet.
Looking forward to your feedback,
RAJA C S N,
GLOBALedge Training Academy,
thanks for such a useful information. If we use MS Access and you put in a key, then this copy past option will not work and Access will not accept an entry with the same data ( to which key has been put up).
From India, Bangalore
For Excel learning... nothing to beat www.mrexcel.com
Register here for free and get weekly lessons - easy tips, features... in digestible chunks.
Give it a shot - you will love it.
From India, Delhi
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network. Add the url of this thread if you want to cite this discussion.