EXACT function comes under the TEXT category in Excel.
EXACT FUNCTION is very useful and quite handy if we need to do a strict comparison between two strings.
The comparison is strict i.e. it is case sensitive. (It differs “W” from “w”).
The output of the function is TRUE or FALSE as per the comparison.
It returns True if both texts are exactly same and FALSE if both strings are not same.
*Fonts, Color etc. doesn’t play any role in comparison.
PURPOSE OF EXACT FUNCTION IN EXCEL
EXACT FUNCTION compares two different TEXTS and returns TRUE if both are strictly same or FALSE if any of the TEXT is not same.
PREREQUISITES TO LEARN EXACT
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the financial terms is an advantage for the use of such formulas.
- Of course, Excel software.
The Syntax for the function is
=EXACT( TEXT1, TEXT2)
EXAMPLE:EXACT FUNCTION IN EXCEL
LET US PUT DIFFERENT STRINGS IN TWO COLUMNS AND APPLY EXACT FUNCTION IN THE THIRD AND CHECK HOW MANY RETURN THE TRUE AND HOW MANY RETURN THE FALSE AS OUTPUT.
STEPS TO USE EXACT FUNCTION
The texts are put in two column i.e. J AND K from row no. 11 to 14.
J column will be compared with the help of EXACT FUNCTION with the K column.
The function used in row 11 is
and similarly down the line.
This function compares the text stored in J11 with the text stored in K11 AND GIVES THE OUTPUT AFTER COMPARISON as shown in the pictures under CHECK HEADING.
COMPARING TWO TEXT STRING WITHOUT EXACT FUNCTION
the two strings can be compared even without using the EXACT FUNCTION. The operator for comparison is “==”.
If we need to compare the text1 to text2, we can simply write text1==text2.
It’ll return the same result as, EXACT(text1,text2) i.e.
TRUE if text1=text2
FALSE if text1 is not equal to text2.
OTHER WAYS TO REACH THIS ARTICLE
COMPARE TWO TEXT, COMPARE TO STRINGS, EQUAL TO OPERATOR, HOW TO EQUATE TEXT