In Google Sheets, the EXACT function is used to determine whether two values are identical. The function takes two arguments: the first is the value to be compared, and the second is the value to be used as the comparison criteria. If the two values are identical, the function will return TRUE; otherwise, it will return FALSE. The EXACT function can be used to compare text values, numbers, or dates.
The EXACT function syntax in Google Sheets is: =EXACT(string1,string2)
The EXACT function returns TRUE if the two strings are exactly the same, and FALSE if they are not.
One way to use EXACT is to use it as a filter in Google Sheets. For example, if you have a list of items and you want to find only the items that have the word "apple" in them, you can use the EXACT function to do that. In the filter menu, select "EXACT" and then type "apple" into the text box. This will return a list of all the items in your original list that have the word "apple" in them.
There are a few instances where you should not use EXACT in Google Sheets. One is if you are looking to compare two values and want to return a boolean value of true if the two values are exactly equal, otherwise false. In this case, you should use the =EQUAL() function. Another instance is if you are looking to find the location of a value in a list, and want to return the index of the value if it is found, or -1 if it is not found. In this case, you should use the =INDEX() function.
Some similar formulae to EXACT in Google Sheets are: =FIND("text", "text") =SEARCH("text", "text") =MATCH("text", "text") =LEN("text") =LEFT("text", number_of_characters) =RIGHT("text", number_of_characters) =MID("text", start_position, number_of_characters)