+1 Other
Hi All,
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,
Regards,
RAJA C S N,
Director,
GLOBALedge Training Academy,
Erode 9443498027
GLOBALedge TRAINING ACADEMY
From India, Madras
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,
Regards,
RAJA C S N,
Director,
GLOBALedge Training Academy,
Erode 9443498027
GLOBALedge TRAINING ACADEMY
From India, Madras
Dear Raja,
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).
Swati
From India, Bangalore
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).
Swati
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.
Cheers
From India, Delhi
Register here for free and get weekly lessons - easy tips, features... in digestible chunks.
Give it a shot - you will love it.
Cheers
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.
Add the url of this thread if you want to cite this discussion.
#Subject List: excel formulas data validation Country-India City-India-Madras
Excel function dictionary.xls
