Business analysisExcel

How to compare two columns in Excel

Comparing two columns in Excel allows to see if there are some missing or different values between the two columns. let’s take an excel to better understand.

we have the following table and will compare column c1 and c2

Here the difference is a quite clear, we have 4 in column C1 and 5 in C2.

we will use the match function to compare between the two columns

As you can see here, we have a different value where we have #N/A. it means we have value 4 in C1 and value 6 in C2.

the function that we used is match(A2, C:C, 0)

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button