Checking if entries are really the same

To check if two cells are the same you can use


This returns TRUE if the values are the same or the text is the same ignoring case sensitivity.

In the above formula TEST will equal test.

To check if entries are identical, taking into account upper and lower case, then you can use


In this case comparing TEST and test will return FALSE.

Related Posts