avoid duplication in a column in excel

[S.G.Pillai]

I have to type many tags one after the other. How will i be able to know
wheather i am reapeating the same tag which has been already entered. and how
this can be prevented.

I need the number of tags to appear in the top most column as i enter the
tag. is it possible in excel. If anybody can help it would be a great help
fro me
bye
thanks in advance

[Bob Phillips]

Use data validation with a custom allow type, and a formula of

=COUNTIF($A$1:A2,A2)=1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"S.G.Pillai" <[email protected]> wrote in message
news:[email protected]...
> I have to type many tags one after the other. How will i be able to know
> wheather i am reapeating the same tag which has been already entered. and
how
> this can be prevented.
>
> I need the number of tags to appear in the top most column as i enter the
> tag. is it possible in excel. If anybody can help it would be a great help
> fro me
> bye
> thanks in advance