Prevent Duplicate Enteries

[anubhavmaheshwar]

Hi Excel Leaders,
Need help in achieving following:
I got 8 columns
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]M[/TD]
[TD]W[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]=concatenate(a1,b1,c1,d1,e1,f1,g1)[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]M[/TD]
[TD]W[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]=concatenate(a1,b1,c1,d1,e1,f1,g1)[/TD]
[/TR]
</tbody>[/TABLE]

Now I want to avoid duplicate values in Column H

Please help me...

 

[GopalaKrishnaJ]

Using Datavalidation

in Custom section try this formula by selecting the range from A:G till filled

=COUNTIF($H:$H,$H1)=1

 

[anubhavmaheshwar]

Nuup its not working any other way