{"id":1392,"date":"2018-12-05T07:32:06","date_gmt":"2018-12-05T01:32:06","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1392"},"modified":"2018-12-05T07:32:06","modified_gmt":"2018-12-05T01:32:06","slug":"compare2-to-cpmare-two-sheets-in-formulas","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1392","title":{"rendered":"Compare2, a tool to compare two sheets using formulas"},"content":{"rendered":"<p>Tool will compare between two sheets using formula\/functions method.<br \/>\nOnce you type in full folder locations (for both files), file names and sheets names in file1 and file2.<\/p>\n<p>Make sure these two files are open, then sheet will be updated with comparison results, showing that every cell is checking for its equivalent addresses from both sheets in both files.<\/p>\n<ul>\n<li>If cell in &#8216;Compare&#8217; worksheet is blank, it means both equivalent cells in the two worksheets are blank.<\/li>\n<li>If it is green &#8216;Y&#8217;, that means they are identical in value.<\/li>\n<li>If it is red &#8216;N&#8217;, it means they are not equal\/<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/Compare2012-08-28-141550.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1396\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/Compare2012-08-28-141550-300x218.jpg\" alt=\"\" width=\"283\" height=\"206\" \/><\/a> <a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/Compare2012-08-28-141501.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1395\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/Compare2012-08-28-141501-300x260.jpg\" alt=\"\" width=\"240\" height=\"208\" \/><\/a> <a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/Compare2012-08-28-141500.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1394\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/Compare2012-08-28-141500-300x260.jpg\" alt=\"\" width=\"246\" height=\"213\" \/><\/a> <a href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/Compare2012-08-28-141553.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-1393\" src=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/Compare2012-08-28-141553-300x217.jpg\" alt=\"\" width=\"286\" height=\"207\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div class=\"row\">\n<div class=\"col-md-6 text-right\"><a class=\"btn btn-primary btn-lg\" href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/Compare2.xlsx\"><i class=\"fa fa-download\"><\/i> Download Compare2<\/a><\/div>\n<div class=\"col-md-6\"><a class=\"btn btn-primary btn-lg\" href=\"https:\/\/1drv.ms\/x\/s!An4iomsT7EVO2Mt0IV8D-WV-QDbyoA\"><i class=\"fa fa-cloud\"><\/i> Excel Online<\/a><\/div>\n<\/div>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tool will compare between two sheets using formula\/functions method. Once you type in full folder locations (for both files), file names and sheets names in file1 and file2. Make sure these two files are open, then sheet will be updated with comparison results, showing that every cell is checking for its equivalent addresses from both&#8230;<\/p>\n<p class=\"more-link-wrap\"><a href=\"https:\/\/xlfxs.com\/?p=1392\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &ldquo;Compare2, a tool to compare two sheets using formulas&rdquo;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1397,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,3,80,35,6],"tags":[],"class_list":["post-1392","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-conditional-formatting","category-formulas","category-if","category-logical","category-standard_functions"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1392"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1392\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1397"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}