Re: double data
- From: davidm <davidm.1xw4ez_1130970068.0103@xxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 2 Nov 2005 05:28:54 -0600
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
.
- References:
- double data
- From: xtrmhyper
- double data
- Prev by Date: Re: double data
- Next by Date: Re: Menu of *** names
- Previous by thread: Re: double data
- Next by thread: mailing
- Index(es):
