nonduplicate entries formula- limit on cells applied??

[mayegzz]

Hi everyone,

I am working on a data validation formula. It works good, except tha
it is only letting me apply the formula to 375 lines of the column
instead of the 2,000 lines that i would like it to be applie
to......does anyone know how i can fix it????

This is the formula I entered in the first field ...then i copied an
pasted it to the rest of the fields...but it only accepted th
validation formula for 375 lines:::

=COUNTIF ($F$11:$F375,F11)=1


I hope someone can help!

Thanks guys

 

[Frank Kabel]

Hi
use
=COUNTIF ($F$11:$F2000,F11)=1