How to avoid repetition of values in a row or a column?
 

I was wandering how can I avoid the repetition of values in a certain row or
column. If I have digits from 1 to 9 and have a row with 9 columns, can I put
all the values in the row without repetition subject to some constraint?

How to avoid repetition of values in a row or a column?
 

See:

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


--
Gary''s Student - gsnu200844


"Kapil Nepal" wrote:

I was wandering how can I avoid the repetition of values in a certain row or
column. If I have digits from 1 to 9 and have a row with 9 columns, can I put
all the values in the row without repetition subject to some constraint?