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

[DonkeyOte]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.