This morning, I had a thought that I cannot shake off; I wonder if I understood your original question correctly. Can I just ask exactyl what you were asking please;
1. That you want to constrain the value the user can enter into the cells in a specific column. 2. That you want to make sure that the value the user tried to enter into a cell in a specific column is unique in that column. By this, I mean that the number 1 can appear in only one cell in the column as can the number 2, 3, 4, etc. If your requirement is described by number 1 above then the data validation is the way to go but if it is described by number 2 above then it may well be that a macro is the only way to proceed as it will be able to check the values in the cells and determine 'uniqueness'. There are functions that you can use to look nto a column to check whether a value already exists but they cannot do much to prevent the user from entering a value into a cell. A VB macro would be able to display a message box, disallow entry of the value, etc. Yours Mark B hima bindu-2 wrote: > > Hi, > > I have the following requirement: > > Suppose there is a column called Id in Excel Sheet. I need to provide some > data validation for that column so that only unique values can be entered. > > Id > 1 > 2 > 3 > 4 > . > . > . > > Can some body suggest the possible approaches? > > -- > With regards, > B.R.Hima Bindu. > > Stephen > Leacock<http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html> > - "I detest life-insurance agents: they always argue that I shall some > day > die, which is not so." > > -- View this message in context: http://old.nabble.com/Unique-value-for-a-column-in-a-Excel-tp27402140p27420937.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
