Excel Functions Tutorials
- Excel Formulas Cheatsheet
- Financial Functions in Excel
- Logical Functions in Excel
- TEXT Functions in Excel
- Lookup Reference in Excel
- Address Function in Excel
- Choose Function in Excel
- Column Function in Excel
- Columns Function in Excel
- REPLACE Function in Excel
- GetPivotData in Excel
- HLOOKUP in Excel
- Hyperlink Excel Function
- INDIRECT Function in Excel
- LOOKUP Excel Function
- Match Excel Function
- VLOOKUP Excel Function
- INDEX Excel Function
- VLOOKUP vs HLOOKUP
- Maths Functions in Excel
- POWER Function in Excel
- EVEN Function in Excel
- ODD Function in Excel
- ABS Function in Excel
- SUM Function in Excel
- SUMPRODUCT Function in Excel
- SUBTOTAL Excel Function
- ROUND in Excel
- AGGREGATE Excel Function
- PRODUCT Excel Function
- RAND Excel Function
- LOG Excel Function
- EXPONENTIAL Excel Function
- SUMIF in Excel
- TAN Excel Function
- CEILING Excel Function
- LN Excel Function
- SIGN Excel Function
- COS Excel Function
- FLOOR Function in Excel
- SIN Excel Function
- Date and Time Function in Excel
- Statistical Function in Excel
Excel EXACT Function (Table of Contents)
EXACT Function in Excel
EXACT function is categorized as Text function in excel. The EXACT function in Excel is used to compare two text strings or values are exactly the same or not if so, returns TRUE else returns FALSE. The Excel Exact function is case-sensitive.
The EXACT in Excel returns TRUE if the two strings/values are the same in the supplied cells and returns FALSE if the two strings are different.
EXACT Formula Excel
Below is the EXACT Formula in Excel.
The EXACT formula excel has two compulsory parameters i.e. text1, text2.
- text1: It is the first string which we wish to compare.
- text2: It is the second text string.
How to Use the EXACT Function in Excel?
EXACT function in Excel is very simple and easy to use. Let understand the working of Excel EXACT function by some examples. The EXACT function in Excel can be used as worksheet function and as VBA function.
EXACT Function as Worksheet Function.
EXACT in Excel Example #1
In the first example, we compare the two string s in column text 1 and text 2 and apply the Exact formula excel in the output column as shown in the function column and the output will be as shown in the below table. The EXACT in Excel returns the TRUE where the text 1 and text are the same and FALSE where the text 1 and text2 values are not exactly the same.
EXACT in Excel Example #2
Suppose we wish that users of our worksheet enter data in the PROPER case in the Proper text-only column. So we can achieve it by using a custom formula based on the EXACT formula Exceland other functions.
Let’s consider the below table and you have to apply the restriction in the Proper text the only column in the below table.
First, select the C18 cell then click on data validation under the Data tab and select Data Validation. Change the validation criteria to custom and input the EXACT formula Excel =AND(EXACT(D18,PROPER(D18)),ISTEXT(D18)).
That’s it, now if you type a NONproper word in the Proper text-only column it will show you an error message like as follows:
EXACT in Excel Example #3
The EXACT in Excel is very useful when you have case-sensitive data.
In this example, we take a set of products where the case-sensitive products are available in the list.
As shown above, there are four products soft toys two being in lowercase and other in uppercase Heres we are looking out for numeric values, SUMPRODUCT + EXACT is an exciting and flexible way to do a case-sensitive lookup. We can use the EXACT formula Excel to be used is
The output is: 300
The EXACT in Excel can be used as a VBA function.
In VBA we can compare two string using strcomp function here is the example as follows:
Dim Lresult as string // declare the lresult as string
Lresult = StrComp (“Tanuj”, “tanuj”)
MsgBox(Lresult) //Output will show in MsgBox
Output will be 0 as String Tanuj and tanuj are not exactly matched.
Things to Remember About the EXACT Function in Excel
- Excel Exact function is used to compare two strings, you can also use the equal sign in a formula (text1=text2) to compare text strings. However, the equal sign is not case sensitive.
You can download this EXACT Function in Excel template here – EXACT Function Excel Template
This has been a guide to EXACT Function in Excel. Here we discuss the EXACT Formula excel and how to use EXACT function along with excel example and downloadable excel templates. You may also look at these useful functions in excel –