Learn How to use Excel Exact Formula:
Excel Exact Formula compare two cells and returns True if they match, otherwise it returns False. Importantly, Exact Function is Case-Sensitive. However, it doesn’t consider the formatting differences.
Exact Function works with Text and Numbers both.
Exact Function Syntax: Exact(Text1, Text2)
Text1 and Text2: Cells having Text strings or Data that has to be compared.
Example – Excel Exact Formula:
Since Exact Function is Case-Sensitive, the result of Example – 1 is False.
Example – 2 is True. Both Cells are same.
Hope you may find this useful.
You may also consider learning Excel Case-Insensitive Match.