duplication validation

  • Thread starter Thread starter icestationzbra
  • Start date Start date
I

icestationzbra

hi,

i wanted to perform validation for duplication of entries in a column.

i went to chip pearson's website

http://www.cpearson.com/excel/NoDupEntry.htm

and looked this up:

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

however, i am not getting the desired results.

it validates for only the immediately previous entry.

for example, if i enter duplicates in consecutive cells, it gives me a
error. if the cells are far apart in the column, i do not get a
error.

what gives?

thanks in advance,

mac
 
chip,

thanks a lot for responding.

the file is really huge. its about 12 MB, its got loads of macros an
pivot tables and the works.

i tried the validation on a new blank xl sheet, and it work
perfectly.

the range over which i wanted to perform this validation, already ha
data in it. going forward, i wanted the additions to be tested. coul
that be the reason, that data already existed?

i had another question about validations, if you would not min
answering in this thread.

i want to run WEEKNUM function over a column. is it possible to run i
thru data validation, rather than entering the formula in a cell an
dragging the formula down the column?

thank you,

mac
 
Back
Top