{"id":10397,"date":"2020-06-15T23:09:36","date_gmt":"2020-06-15T17:39:36","guid":{"rendered":"https:\/\/www.thewallstreetschool.com\/blog\/?p=1113"},"modified":"2020-06-15T23:09:36","modified_gmt":"2020-06-15T17:39:36","slug":"how-to-compare-two-columns-in-excel","status":"publish","type":"post","link":"https:\/\/www.thewallstreetschool.com\/stg-new\/how-to-compare-two-columns-in-excel\/","title":{"rendered":"How to Compare Two Columns in MS Excel?"},"content":{"rendered":"\n

Comparing two columns in excel is on of the most basic and important step of data analysis. There could be two cases while we are comparing the data points in a column, as you can see in table of content below –<\/p>\n\n\n\n\n\n

To find the columns which have same value in a row<\/strong><\/h2>\n\n\n\n

To check if both the columns have same value in a row, we can apply a simple \u201c=\u201d to check. If the values are same, it will return \u201cTRUE\u201d else it will return \u201cFALSE\u201d.<\/p>\n\n\n\n

Suppose we are comparing column A and B in Row 1, the exact syntax would be –<\/p>\n\n\n\n

=A1=B1<\/strong><\/p>\n\n\n\n

For example, view the video below –<\/p>\n\n\n\n

\n
https:\/\/vimeo.com\/429184135<\/div>\n<\/figure>\n\n\n\n

To find the values of one column which are also present in the other column<\/strong><\/h2>\n\n\n\n

If you want to compare two columns and check if values in one column exists in the another column and vice versa you can check with following ways:<\/p>\n\n\n\n

    \n
  1. Using MATCH formula<\/strong><\/li>\n<\/ol>\n\n\n\n

    MATCH formula is used to determine if a particular value is present in an array. It returns the row number in which the value is present. The exact syntax is as given below –<\/p>\n\n\n\n

    =MATCH(lookup value, lookup array, [match type])<\/strong><\/p>\n\n\n\n

      \n
    • Lookup value- the value you want to look up<\/li>\n
    • Lookup array- The array where you want to find<\/li>\n
    • Match Type- Exact or Approximate (0 is used for exact match)<\/li>\n<\/ul>\n\n\n\n\n\n

      To compare the two columns using MATCH formula, we will select a particular value in Column 1 as ‘Lookup Value’ and find out whether it exists in Column 2, which will be selected as ‘Lookup Array’ in this case.<\/p>\n\n\n\n

      This would return us with the Row number in the Column 2 where the value exists. If it doesn’t exist, then it would return an error.<\/p>\n\n\n\n

      For example, view the video below –<\/p>\n\n\n\n

      \n
      https:\/\/vimeo.com\/429340513<\/div>\n<\/figure>\n\n\n\n
        \n
      1. Using<\/strong> Conditional Formatting<\/strong><\/li>\n<\/ol>\n\n\n\n

        You can also use conditional formatting to determine if the two columns have same values or not as demonstrated in the video below.<\/p>\n\n\n\n

        \n
        https:\/\/vimeo.com\/429340320<\/div>\n<\/figure>\n","protected":false},"excerpt":{"rendered":"

        Comparing two columns in excel is on of the most basic and important step of data analysis. There could be two cases while we are comparing the data points in a column, as you can see in table of content below – To find the columns which have same value in a row To check […]<\/p>\n","protected":false},"author":45,"featured_media":969,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[798],"tags":[],"class_list":["post-10397","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/posts\/10397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/comments?post=10397"}],"version-history":[{"count":0,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/posts\/10397\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/media\/969"}],"wp:attachment":[{"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/media?parent=10397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/categories?post=10397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thewallstreetschool.com\/stg-new\/wp-json\/wp\/v2\/tags?post=10397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}