matching the two values [SOLVED]

[webmax]

Hi


I have a two below values if put the =A1=A2 it shows the true value even though it is a case sensitive. I want true value only when both the value match exactly how to do this.


Country 1 Country 1

India INDIA

 

[vijay.vizzu]

Dear Webmax


You can use Excel built in Function EXACT. It will compare text1 and text2

 

[webmax]

thanks vijay