## 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 FALSE`

## Examples 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 FALSE
```

**Example 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`