Do the values in a range of cells include all members of a set
The formula will prevent entering the same value twice.... the "COUNTIF($E2:$E$25,E2)=1" part does
that - try it....
HTH,
Bernie
MS Excel MVP
Thanks Bernie!
That helps prevent me from entering an invalid position and that is helpful.
But I what I really want to prevent is entering the same position more than
once.
|