In the following example, as you can see in the photo, comparing one Text string with a List of Cells can be identified by the EXACT function.
=EXACT("word",A2:A10)----->>>>answer is FALSE,FALSE,TRUE,TRUE,FALSE,FALSE,FALSE,FALSE,FALSE,EXACT function
The EXACT function is one of the TEXT functions of Excel.
It checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive.
EXACT arguments
The EXACT function has 2 arguments:
1. Text1 is the first text string.
2. Text2 is the second text string.
