RAJACSN
39

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
[IMG]https://www.citehr.com/misc.php?do=email_dev&email=Z2V0YS5lcm9kZUBnbWFpbC 5jb20=[/IMG]
GLOBALedge TRAINING ACADEMY

From India, Madras
Attached Files (Download Requires Membership)
File Type: xls COUNTIF FUNCTION IN EXCEL.xls (40.5 KB, 1996 views)

ilyaskazi
To know more excel formulas you can visit my blog here...
LiveExcel - Formula


swati.jain0104
5

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
amit.p
here u go :idea:
From India, Thana
Attached Files (Download Requires Membership)
File Type: xls count if.xls (16.5 KB, 751 views)

Raj_at_CiteHR
5

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
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.