Wrong again. You can use a data validation to ensure uniqueness within a column. Take a look at this;
http://excel.tips.net/Pages/T002650_Ensuring_Unique_Values_in_a_Column.html But you will need to create a data validation for each cell in the column. 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-tp27402140p27421385.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]
