Data validation

[surya9]

Hi
how to validate two columns to get exact value seraing whole of two columns and provide only when Col1, row 2 value = col2, row 2 value.

eg: John=John

I mean my current formula is =if(h1=m1,1,0). I want a formula where H:H=M:M, but must return true only if h1=m1, h2= m2, etc.
I hope I am clear
Thank you

[Richard Schollar]

Perhaps:

=SUMPRODUCT(--(H1:H100=M1:M100))=ROWS(H1:H100)

Adjust ranges to suit (you can't use whole column refs with Sumproduct eg A:A if using xl2003 or below)