poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hima Bindu <himabindu.b...@gmail.com>
Subject Re: Unique value for a column in a Excel
Date Wed, 03 Feb 2010 04:46:17 GMT
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 <markbrdsly@tiscali.co.uk> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message