What is the EXACT function in Excel?
The EXACT function is one of the TEXT functions of Excel.
It checks whether two text strings are exactly the same, and returns TRUE or FALSE.
EXACT is case-sensitive.
We can find this function in TEXT category of insert function Tab.
How to use EXACT function in excel
1.Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select TEXT category.
5. Select EXACT function.
6. Then select ok.
7. In the function arguments Tab you will see EXACT function.
8. Text1 is the first text string.
9. Text2 is the second text string.
10. You will see the results in formula result section.
=EXACT("WORD","word")----->>>>answer is FALSEExamples of EXACT function in Excel
Example 1:
How to compare two cell(string) in excel
In the following example, as you can see in the below photo, comparing two cell with each other can be identified by the EXACT function.
=EXACT(A2,B2)----->>>>answer is FALSE
=EXACT(A5,B5)----->>>>answer is TRUE
=EXACT("WORD","word")----->>>>answer is FALSEExample 2:
How to compare a cell(string) with list of cell
In the following example, as you can see in the photo, comparing one Text string with a List of Cells can be identified by the EXACT function.
=EXACT("word",A2:A10)----->>>>answer is FALSE,FALSE,TRUE,TRUE,FALSE,FALSE,FALSE,FALSE,FALSE,Example 3:
comparing between EXACT and EQUAL
Example 4:
How to Count specific words in a range
In the following example, as you can see in the photo, Count specific words in a range can be identified by the EXACT and SUMPRODUCT functions.
=SUMPRODUCT(--EXACT("word",A2:A10)) ----->>>>answer is 2