EXACT Function in Excel
In this tutorial, you will learn the EXACT formula in excel. EXACT function in excel is useful to compare two data and give the result of TRUE logic value if the two of them are exactly the same or FALSE if not. This EXACT formula in excel is case sensitive.
Why do We Need to Learn EXACT Formula in Excel?
In the processing that we do on a spreadsheet, sometimes we need to do a similarity comparison between two texts to be used in a formula that utilizes TRUE and FALSE logic values in its process. In the process, maybe we also need the comparison to be case sensitive on those two texts so the comparison result will not be wrong. This cannot be done if we use the manual comparison process in the spreadsheet.
The case example is when we want to use a product name data to look at the details of the product in a spreadsheet. In the data that we save on the spreadsheet, there is a product name that is the exactly same as the product name that we look for, and they are only differentiated with the capital or noncapital letters. If we use a manual comparison process to find the product name, then it will not detect the difference between the capital and noncapital letters on the product names. If the products have hundreds or even thousands of data, then it will be hard if the alternative of this is we have to look at each of the data one by one.
To help you in getting the comparison process right and make it pay attention to the capital or noncapital letters, then you can use the EXACT formula in excel. EXACT function in excel is useful for the comparison process of two data which also pays attention to the capital or noncapital letters of the two data. The EXACT formula in excel is very useful for you to learn if you often use a text comparison process in your processing/analysis on the spreadsheet.
What is the EXACT Function in Excel?
EXACT function in excel is a function with the usage objective to get the logic value of TRUE or FALSE from the result of two data comparisons by having the case sensitive factor on the comparison process. The EXACT function in excel will give TRUE if the two data are exactly the same and FALSE if not.
Generally, the input of this formula can be explained as follows:
=EXACT(text1, text2)
Note:
 text1 = the first data to be compared
 text2 = the second data to be compared
How to Use EXACT Formula in Excel?
The following will explain the writing of the EXACT function in excel. The EXACT formula in excel needs two required inputs which are the two data that you want to compare to get the TRUE or FALSE result.
Using the EXACT Function in Excel

Type equal sign ( = ) in the cell where you want to put the result in

Type EXACT (can be with large and small letters) and open bracket sign after =

Input the first data or cell coordinate where the first data which you want to compare is after the open bracket sign. If you want to type a text manually without using a cell coordinate, then do not forget to type the text between two quotes signs (“”). Then type a comma sign ( , )

Input the second data or cell coordinate where the second data which you want to compare is. If you want to type a text manually without using a cell coordinate, then do not forget to type the text between two quotes signs

Type close bracket sign
 Type Enter

The process is done!
Exercise
After you have learned the stepbystep writing of the EXACT formula in excel, now is the time to deepen your understanding by doing the following exercise!
Download the exercise file and answer the questions. Download the answer key file if you have done them and want to check your answers or if you are confused about how to answer the questions!
Link of the exercise file:
Download here
Questions
 What is the logic value from the comparison result of the two texts in the row no. 1?
 What is the logic value from the comparison result of the two texts in the row no. 2?
 What is the logic value from the comparison result of the two texts in the row no. 3?
Link of the answer key file:
Download here
Additional Notes
If you want to compare two data without being case sensitive, then you can use an equal sign ( = ) for your comparison process.