{"id":1255,"date":"2018-07-02T17:21:48","date_gmt":"2018-07-02T17:21:48","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1255"},"modified":"2023-11-02T19:34:48","modified_gmt":"2023-11-02T19:34:48","slug":"exact","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/exact\/","title":{"rendered":"EXACT function"},"content":{"rendered":"\n

Excel EXACT Function allows you to compare two text strings to check if they are exactly the same.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n\n

EXACT(text1, text2)<\/strong><\/p>\n\n\n\n

Arguments<\/h2>\n\n\n\n
text1<\/b><\/td>The first text string you want to compare.<\/td><\/tr>
text2<\/b><\/td>The second text string you want to compare.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

How to use<\/h2>\n\n\n\n

The EXACT function is a simple yet powerful tool for comparing two text strings. Here’s how to use it:<\/p>\n\n\n\n

Let’s assume you have two text strings, “apple” and “apple,” and you want to check if they are identical. You can use the EXACT function like this:<\/p>\n\n\n\n

=EXACT(\"apple\", \"apple\")<\/code><\/pre>\n\n\n\n
This formula will return TRUE<\/code> because both text strings are exactly the same.<\/p>\n\n\n\n
Now, let’s say you want to compare “apple” with “orange” using the EXACT function:<\/p>\n\n\n\n
=EXACT(\"apple\", \"orange\")<\/code><\/pre>\n\n\n\n
This time, the formula will return FALSE<\/code> because the two text strings are not identical.<\/p>\n\n\n\n
One thing to keep in mind is that the EXACT function is case-sensitive. So, if you compare “apple” with “Apple,” it will return FALSE<\/code> because the capitalization is different.<\/p>\n\n\n\n
You can also use the EXACT function in more complex formulas and combine it with other functions to perform tasks like conditional formatting, data validation, or filtering data based on exact matches.<\/p>\n\n\n\n
For example, you can use it in an IF<\/code> function to create a condition that checks if two cells in Excel are exactly the same:<\/p>\n\n\n\n
=IF(EXACT(A1, B1), \"Match\", \"No Match\")<\/code><\/pre>\n\n\n\n
This formula will display “Match” if the content of cell A1 is exactly the same as the content of cell B1; otherwise, it will display “No Match.”<\/p>\n\n\n\n
So, the EXACT function is a handy tool when you need to ensure that your data matches precisely, and it’s especially useful when dealing with textual data in Excel.<\/p>\n\n\n\n
Additional Information<\/h2>\n\n\n\n
The EXACT function is case-sensitive, meaning it considers uppercase and lowercase letters as different characters. So, “apple” and “Apple” are not considered the same by the EXACT function.<\/p>\n","protected":false},"excerpt":{"rendered":"
Excel EXACT Function allows you to compare two text strings to check if they are exactly the same. Syntax EXACT(text1, text2) Arguments text1…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nEXACT function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/exact\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EXACT function\" \/>\n<meta property=\"og:description\" content=\"Excel EXACT Function allows you to compare two text strings to check if they are exactly the same. Syntax EXACT(text1, text2) Arguments text1...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/exact\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-02T17:21:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-02T19:34:48+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/exact\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/exact\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"EXACT function\",\"datePublished\":\"2018-07-02T17:21:48+00:00\",\"dateModified\":\"2023-11-02T19:34:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/exact\/\"},\"wordCount\":306,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/exact\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/exact\/\",\"name\":\"EXACT function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-02T17:21:48+00:00\",\"dateModified\":\"2023-11-02T19:34:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/exact\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/exact\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/exact\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"EXACT function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"EXACT function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/functions\/exact\/","og_locale":"en_US","og_type":"article","og_title":"EXACT function","og_description":"Excel EXACT Function allows you to compare two text strings to check if they are exactly the same. Syntax EXACT(text1, text2) Arguments text1...","og_url":"https:\/\/officetuts.net\/excel\/functions\/exact\/","article_published_time":"2018-07-02T17:21:48+00:00","article_modified_time":"2023-11-02T19:34:48+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/exact\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/exact\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"EXACT function","datePublished":"2018-07-02T17:21:48+00:00","dateModified":"2023-11-02T19:34:48+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/exact\/"},"wordCount":306,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/exact\/","url":"https:\/\/officetuts.net\/excel\/functions\/exact\/","name":"EXACT function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-02T17:21:48+00:00","dateModified":"2023-11-02T19:34:48+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/exact\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/exact\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/exact\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"EXACT function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1255"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1255"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1255\/revisions"}],"predecessor-version":[{"id":16376,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1255\/revisions\/16376"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}