Re: double data


To use data validation to prevent duplicate entries in Column A, say.
Highlight the column and enter the following formula in the appropriate
Data Validation box:

=Countif(A:A,A1)=1


David.


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=20645
View this thread: http://www.excelforum.com/showthread.php?threadid=480979

.

Relevant Pages

  • How to prevent double entry in excel?
    ... You can use Data Validation to do this. ... want to prevent any duplicate entries. ... you can create a custom message that will pop ... You are attempting to make an entry that already exsists! ...
    (microsoft.public.excel.misc)
  • RE: Am I missing some easy solution to my problem?
    ... To prevent duplicate entries use Data Validation from menu Data>: ... Highlight the range, lets say A1:A100 ... Choose the command Data, ...
    (microsoft.public.excel.worksheet.functions)
  • Duplicate entries
    ... Andrew ... This article explains how to use data validation to prevent the creation of duplicate entries in a list. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: double data
    ... To use data validation to prevent duplicate entries in Column A, ... Highlight the column and enter the following formula in the appropriate ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Range of data within a column
    ... >I'm trying to figure out a way to highlight the text color in cells that ... If the user inputs a number outside that range, Data Validation will disallow ... keyboard shocker to that message). ...
    (microsoft.public.excel.worksheet.functions)