I like to format a column such that it allows only distinct values. for
eg in the column A i have 10 numbers 1to 10 (A1 to A10) . if i enter
any value between 1 and 10 in A11 it should not allow. A11,A12.....etc
should allow only distinct values. pls help me to do this

thanks in advance


--
parthaemail
------------------------------------------------------------------------
parthaemail's Profile: http://www.excelforum.com/member.php...o&userid=31311
View this thread: http://www.excelforum.com/showthread...hreadid=519287