Expanding data validation

Hi friends,
I want to enter a value >0 and avoide duplicate value in the following validation formula.

Please Login or Register  to view this content.

Any help will be highly appreciated.

Thanking you.

Try this out

=AND(COUNTIF($L$2:$L$5000,L2)=1,ISNUMBER(L2),L2>0)

Your formula will restrict duplicate entries but not letters..

However, this formula will restrict numbers < 1, along with restriction towards entering any letters and duplicates..

Hope it helps!

Deep

Maybe:


=AND(L2>0,COUNTIF($L$2:$L$5000,L2)=1)

Solved. Thank you to both of you.