Using EXACT function in Excel to compare text or data
Using Exact function in Excel to compare text or data can be quite useful when you have an old data list and you wish to compare it with an updated list from your database administrator. The function ‘Exact’ in Excel compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into an Excel spreadsheet.
Text1 is the first text string.
Text2 is the second text string.
You can also use the double equals (==) comparison operator instead of the EXACT function in Excel to make exact comparisons. For example, =A1==B1 returns the same value as =EXACT(A1,B1).
The following Excel training video demonstrates the use and benefits of the ‘exact’ function while comparing an old list of emails with a newer list. Three emails out of four are outdated!
Watch the video:
MS Excel: EXACT Function (WS)
Excel 2010: Matching Values With EXACT Function