EXACT()
Syntax. EXACT(text1,text2)
Definition. This function checks whether two strings are exactly the same and returns the logical value TRUE or FALSE.
Arguments
text1 (required). The first string to be compared.
text2 (required). The second string to be compared.
Background. You can use the EXACT() function in an array expression to check whether a list contains certain strings. With EXACT(), you can also validate text entered into a form.
This function is case-sensitive but ignores formats.
Example. Assume that after you have entered a list of data, you want to examine the array to check whether it contains a specific character string. The list is entered in the cell range B23:B48, and cell D22 contains the search string. Enter the following formula ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
