Countif Function In Excel - How To Use It To Avoid Duplicate Entries? - CiteHR
Software Professional
Softskills Trainer
Executive - Hr
Training & Employee Development
+1 Other

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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


Attached Files
Membership is required for download. Create An Account First
File Type: xls COUNTIF FUNCTION IN EXCEL.xls (40.5 KB, 1907 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).

here u go :idea:

Attached Files
Membership is required for download. Create An Account First
File Type: xls count if.xls (16.5 KB, 705 views)

For Excel learning... nothing to beat
Register here for free and get weekly lessons - easy tips, features... in digestible chunks.
Give it a shot - you will love it.

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 @ 2020 Cite.Co™