• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

EXACT in Excel

February 16, 2022 by Andrew Childress
Exact Excel

It’s handy to rapidly compare large volumes of data to find exact text matches. Let’s learn how to use EXACT in Microsoft Excel.

When you work in Excel, you may find yourself needing to compare data. This is especially true with text strings. It’s handy to rapidly compare large volumes of data to find exact text matches. Fortunately, Excel has a built-in formula that does exactly that. Let’s learn how to use EXACT in Microsoft Excel.

How to Use EXACT in Excel

Imagine that you have two columns of data, with each cell containing one or more words. You need to evaluate the data to see if the values in a given row of column A match the values in the same row of column B. Of course, you could do this manually. But if you have a large volume of data, studying it manually takes a lot of time, and is quite error-prone.

This is where Excel’s EXACT formula comes in. EXACT automatically studies a pair of values and determines whether they are an exact match. If the match is exact, the formula returns the value TRUE. If the match isn’t exact, Excel will return FALSE when you use the EXACT formula.

To use EXACT in Microsoft Excel, begin by clicking into an empty cell. Here, we’ll use cell C1 to compare the values in cells A1 and B1 for an exact match.

Begin by typing an = sign, which tells Excel that you’ll be inputting a formula. Then, type the EXACT( function. So far, your formula reads:

=EXACT(

Exact Excel

Then, click the first cell that you want to compare, add a comma, and click on the other cell. Your complete formula should be:

=EXACT(A1,B1)

Hit Enter on your keyboard, and Excel analyzes for an exact match. Here, the two cells are an exact match, so Excel returns TRUE.

Exact in Excel

From here, you can copy the formula downward by dragging the corner. Excel will analyze the other pairs. Notice in the case of cells A3 and B3, that the EXACT formula is case-sensitive.

Exact formula Excel

As you can see, it’s easy to find matches in Excel, all thanks to the simple, easy-to-use EXACT function.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Minute formula in Excel MIN in Excel
Next Post: Switch Windows in Excel Switch windows Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top