

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 admininistrator. The function
'Exact' in Excel compares two text strings and returns TRUE if they are
exactly the same, FALSE otherwise. EXACT is casesensitive but ignores
formatting differences. Use EXACT to test text being entered into an
Excel spreadsheet. Syntax EXACT(text1,text2) Text1 is the first text string. Text2 is the second text string. Remarks 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 demontrates 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! 




