Wednesday, October 19, 2011

yogi_Create A Flag To Enforce Only Unique Entries In An Adjacent Column In A Field

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user zsimple21 said:
Google Spreadsheet and enforcing a unique value for fields, not allowing duplicate entries
I have created a google spreadsheet (acting as a database) that has numerous columns, name being of them, and I wanted to make sure the name field is always unique and no row can be created if the name field is the same as another row. Essentially creating a primary key for a database. Does anyone know how to do this in Google Spreadsheets?
If it helps, I created a form to go with the google spreadsheet(database) that will enter the data in to the sheet and would love to ensure a user does not enter the same name as someone else in the list already.
I would love to have a resolution to one of these problems to move on, please help if you can!
----------------------------------