Hi Mark, Thanks for your suggestions. The requirement I need is as mentioned in ur point number 2. So I dont have much option other than setting validation for each cell in that column.
Regards, Bindu. On Tue, Feb 2, 2010 at 8:02 PM, MSB <[email protected]> wrote: > > 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] > >
