Text Function - EXACT

If you want to check whether two sets of data are identical, then give the EXACT function a spin!

The video shows the EXACT function in use.

The final written calculation is below:

=EXACT(B3,C3)

In this formula, the contents of B3 will be checked against C3.

TRUE equals a match and FALSE means a mismatch.