This Blog is dedicated to all Excel Lovers.. This blog is just an attempt of publishing my own as well the Knowledge available on internet about excel at a single place..

Tuesday, October 03, 2006

Validation for Resticting Duplicate Entries in excel.

Validation for Resticting Duplicate Entries in single Column

Use following Formula in Data>>Validation

=COUNTIF($A$1:A1,A1)=1

posted by NC at 11:15 PM

0 Comments:

Post a Comment

Links to this post:

Create a Link

<< Home