Ilyaskazi
Software Professional
RAJACSN
Softskills Trainer
Swati.jain0104
Executive - Hr
Raj_at_CiteHR
Training & Employee Development
+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

Attached Files
File Type: xls COUNTIF FUNCTION IN EXCEL.xls (40.5 KB, 1947 views)

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


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
here u go :idea:
From India, Thana

Attached Files
File Type: xls count if.xls (16.5 KB, 716 views)

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
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.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2021 Cite.Co™