data validation - to enter unique value in the cell

[doynovam]

I have used MS Excell 97 and would like to define the validation rul
over the celles in one column, so that text(or number) value entered i
the every next cell to be unique in relation to the all previou
completed celles.

If somebody knows the decision of the problem

 

[Max]

Try Debra Dalgleish's page at:

http://www.contextures.com/xlDataVal07.html

(Prevent Duplicates)

 

[Frank Kabel]

Hi
have a look at
http://www.contextures.com/xlDataVal03.html