Hi All,
Greetings to you from GLOBALedge. Please find attached an Excel worksheet that describes using the COUNTIF function to avoid duplicate entries. This worksheet also utilizes the DATA VALIDATION option in Excel.
Note: Please enable MACROS when opening this worksheet.
Looking forward to your feedback.
Regards,
RAJA C S N
Director
GLOBALedge Training Academy
Erode 9443498027
[IMG]https://www.citehr.com/misc.php?do=email_dev&email=Z2V0YS5lcm9kZU BnbWFpbC5jb20=[/IMG] GLOBALedge TRAINING ACADEMY
From India, Madras
39Greetings to you from GLOBALedge. Please find attached an Excel worksheet that describes using the COUNTIF function to avoid duplicate entries. This worksheet also utilizes the DATA VALIDATION option in Excel.
Note: Please enable MACROS when opening this worksheet.
Looking forward to your feedback.
Regards,
RAJA C S N
Director
GLOBALedge Training Academy
Erode 9443498027
[IMG]https://www.citehr.com/misc.php?do=email_dev&email=Z2V0YS5lcm9kZU BnbWFpbC5jb20=[/IMG] GLOBALedge TRAINING ACADEMY
From India, Madras
To learn more about Excel formulas, you can visit my blog here:
[LiveExcel - Formula](http://liveexcel.blogspot.com/search/label/Excel%20Formula)
[LiveExcel - Formula](http://liveexcel.blogspot.com/search/label/Excel%20Formula)
Dear Raja,
Thank you for such useful information. If we use MS Access and you input a key, then the copy-paste option will not work, and Access will not accept an entry with the same data to which the key has been assigned.
Swati
From India, Bangalore
Thank you for such useful information. If we use MS Access and you input a key, then the copy-paste option will not work, and Access will not accept an entry with the same data to which the key has been assigned.
Swati
From India, Bangalore
For Excel learning, nothing beats 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
From India, Delhi
Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Excel function dictionary.xls
10 ways to format Excel data.pdf