Use EXACT Function to Compare two Columns

EXACT ( ) Compares two text strings and returns TRUE if they are exactly the same. We can also use IF function to Compare two Columns but with IF function, it doesn’t matter if the text is written in Upper or Lower Case. The EXACT is case-sensitive and Can distinguish between Upper and Lower Case & it also ignores formatting differences.

SYNTAX: EXACT (text1,text2)

text 1: First text String             text 2: Second text String

If the two items of text are exactly the same the result of TRUE will be shown.

If there is any difference in the two items of text the result of FALSE will be shown.

 

 

 

 

 

 

 

EXACT Basics Workbook (71 downloads)

Download the workbook and practice with your Choice of Text.

Be the first to comment

Leave a Reply

Your email address will not be published.


*