Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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)

Posted on Oct 8, 2015 3:02 PM

Reply
1 reply

Oct 8, 2015 3:13 PM in response to jonnj

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:

User uploaded file


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

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.