Formulas > =EXACT()
How to Use EXACT() in Google Sheets
Description
How To Actually Use EXACT() in Sheets
EXACT(string1, string2)
Try EXACT yourself
In cells C1:C10, use the EXACT() formula to compare the strings in A1:A10 with those in B1:B10. The formula should return TRUE if the strings are identical and FALSE otherwise.
Hints (2)
-
Remember to compare each corresponding pair of cells.
-
The EXACT function is case-sensitive.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the EXACT() formula:
Generate a EXACT() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses EXACT(). 2 free AI generations, no signup. Members get unlimited use.
Generate a EXACT() formula