Loading...

Compare Cells With Excel EXACT Function

24,350 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on Dec 27, 2010

http://www.contextures.com/30excelfun... Use the EXACT function in Excel to compare text strings, including the upper and lower case of the characters.

If the contents and case are identical, the EXACT function result is TRUE. If the cells are not identical, the result is FALSE.

You can use EXACT function in Excel data validation, to control what users can enter in a cell.

Use EXACT with a lookup table, to find exact matches for passwords or product codes. You can also pull the related values for the exact match, similar to using VLOOKUP.

Or, use EXACT to count the occurrences of an item in a list, where the contents and case are identical.

Watch this video to see how to use the Excel EXACT function.

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...