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 non-capital letters. If we use a manual comparison process to find the product name, then it will not detect the difference between the capital and non-capital 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 non-capital 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 non-capital 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


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

    EXACT Function in Excel - Screenshot of Step 1

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

    EXACT Function in Excel - Screenshot of Step 2

  3. 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 ( , )

    EXACT Function in Excel - Screenshot of Step 3

  4. 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

    EXACT Function in Excel - Screenshot of Step 4

  5. Type close bracket sign

    EXACT Function in Excel - Screenshot of Step 5

  6. Type Enter
  7. The process is done!

    EXACT Function in Excel - Screenshot of Step 7



Exercise


After you have learned the step-by-step 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

  1. What is the logic value from the comparison result of the two texts in the row no. 1?
  2. What is the logic value from the comparison result of the two texts in the row no. 2?
  3. 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.

EXACT Function in Excel - Screenshot of Additional Notes 1

EXACT Function in Excel - Screenshot of Additional Notes 2





Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on




Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert