{"id":355,"date":"2014-10-08T12:52:04","date_gmt":"2014-10-08T10:52:04","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=355"},"modified":"2023-11-30T01:34:23","modified_gmt":"2023-11-30T00:34:23","slug":"row-differences","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/row-differences\/","title":{"rendered":"Row Differences"},"content":{"rendered":"<p>If you have two rows that you want to compare, for example, sale amount versus amount paid, you can easily filter the differences between these two columns by going in to the <em>Find &amp; Select &gt; Go To Special &gt; Row Differences<\/em>.<\/p>\n<p>Once the cells have been identified, you can color them in and then filter to see each transaction.<br \/>\n<iframe src=\"https:\/\/www.youtube.com\/embed\/cfRP3PBJ-e4?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><br \/>\n<span style=\"color: #0000ff;\"><strong><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/09\/Row-Differences.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><span style=\"color: #0000ff;\">download workbook<\/span><\/span><span class=\"postTitle px-3\">Row-Differences.xlsx<\/span><\/a><\/strong><\/span><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Select the rows that you want to compare<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Row Differences\"  class=\"alignnone size-full wp-image-19797\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-01.jpg\" alt=\"Row Differences\" width=\"749\" height=\"418\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-01.jpg 749w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-01-300x167.jpg 300w\" sizes=\"(max-width: 749px) 100vw, 749px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Press <em><strong>Ctrl + G<\/strong> <\/em>to open the <strong>Go To Dialog.\u00a0<\/strong>Select\u00a0<strong>Special<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Row Differences\"  class=\"alignnone size-full wp-image-19798\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-02.jpg\" alt=\"Row Differences\" width=\"547\" height=\"428\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-02.jpg 547w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-02-300x235.jpg 300w\" sizes=\"(max-width: 547px) 100vw, 547px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> Select <strong>Row Differences<\/strong> and click <strong>OK<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Row Differences\"  class=\"alignnone size-full wp-image-19799\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-03.jpg\" alt=\"Row Differences\" width=\"314\" height=\"330\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-03.jpg 314w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-03-285x300.jpg 285w\" sizes=\"(max-width: 314px) 100vw, 314px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Color the selected cells<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Row Differences\"  class=\"alignnone size-full wp-image-19800\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-04.jpg\" alt=\"Row Differences\" width=\"711\" height=\"595\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-04.jpg 711w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-04-300x251.jpg 300w\" sizes=\"(max-width: 711px) 100vw, 711px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> Now let&#8217;s filter and leave these rows! Go to\u00a0<em><strong>Home &gt; Sort &amp; Filter &gt; Filter<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Row Differences\"  class=\"alignnone size-full wp-image-19801\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-05.jpg\" alt=\"Row Differences\" width=\"1343\" height=\"604\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-05.jpg 1343w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-05-300x135.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-05-1024x461.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-05-768x345.jpg 768w\" sizes=\"(max-width: 1343px) 100vw, 1343px\" \/><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 6:<\/strong><\/span> Go to <em><strong>Paid Column Filter &gt; Filter by Color &gt; <span style=\"color: #ff0000;\">Color Red<\/span><\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Row Differences\"  class=\"alignnone size-full wp-image-19802\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-06.jpg\" alt=\"Row Differences\" width=\"841\" height=\"489\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-06.jpg 841w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-06-300x174.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-06-768x447.jpg 768w\" sizes=\"(max-width: 841px) 100vw, 841px\" \/><\/p>\n<p>Now you have your row differences!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"Row Differences\"  class=\"alignnone size-full wp-image-19803\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-07.jpg\" alt=\"Row Differences\" width=\"717\" height=\"213\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-07.jpg 717w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/10\/Row-Differences-07-300x89.jpg 300w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you have two rows that you want to compare, for example, sale amount versus amount paid, you can easily filter the differences between these two columns by going in to the Find &amp; Select &gt; Go To Special &gt; Row Differences. Once the cells have been identified, you can color them in and then [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":17612,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,37],"tags":[88,53,55],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/355"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=355"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/355\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17612"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}