how to prevent duplicate enteries
I would like to insert a specific index or key number in a column. How to I prevent the entry of a duplicate number?
Mac Pro, Mac OS X (10.7.2)
I would like to insert a specific index or key number in a column. How to I prevent the entry of a duplicate number?
Mac Pro, Mac OS X (10.7.2)
create the key based on something the user does not enter.
you can create an index by using the row() function, or some other combination... like this:
A2=ROW()−2
this is shorthand for, select cell A2, then type (or copy and paste from here) the formula:
=ROW()−2
select cell A2, copy
select cells A2 thru the end of column A, paste
there are many other ideas but knowing specifics about what you want to do will help narrow the field.
how to prevent duplicate enteries