i had used:
=AND(COUNTIF(C:C,C243)=1,ISTEXT(B243))

if the field contains repeated value, it will not prompt immediately. But
only when u select the text field again.

Any1 knows whay?

"kyoshirou" wrote:

can i do a validate in a way so that the
Total value of all rows from column A,B &C is not same from Row 1.

Any ideas?