No Tags Found!


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

Acknowledge(1)
MA
Amend(0)

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
Acknowledge(0)
Amend(0)

here u go :idea:
From India, Thana
Attached Files (Download Requires Membership)
File Type: xls count if.xls (16.5 KB, 766 views)

Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.