i know normal validate is:
=AND(COUNTIF(C:C,C243)=1,ISTEXT(B243))

can i do something like:
=AND(COUNTIF(CONCATENATE(A37,B37,C37,D37))=1,ISTEX T(B244))
__________________________________________________ _________

i mean every row should not have the same values.
A B C D
1 2 3 4
2 3 4 5
2 2 2 4
1 2 3 4
2 2 2 4
the last 2 input will promot error coz all the values are same.
Hope i did bring my message clear. Sry for confusing.




"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?