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,
GLOBALedge Training Academy,
Erode 9443498027


From India, Madras

Attached Files
File Type: xls COUNTIF FUNCTION IN EXCEL.xls (40.5 KB, 1954 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).

From India, Bangalore
here u go :idea:
From India, Thana

Attached Files
File Type: xls count if.xls (16.5 KB, 720 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.

From India, Delhi

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server