## How to remove common values between two columns

*Article updated on February 02, 2018*

**Question:** How do i remove common values between two lists?

**Answer:** The solution in this article, removes common values and the original values, as seen on the picture below. To create a unique list from two columns or two cell ranges, check this article out: Create unique list from two columns

### Excel 2007 array formula in cell D1:

### Download excel sample file for this tutorial.

remove-common-values-between-two-columns.xlsx

(Excel 2007 Workbook *.xlsx)

**Functions in this tutorial: **

**IF(**logical_test;[value_if:true];[value_if_false]**)
**Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

**COUNT(**value1;[value2]**)
**Counts the number of cells in a range that contain numbers

**COUNTIF(**range;criteria**)**

Counts the number of cells within a range that meet the given condition

**INDEX(**array,row_num,[column_num]**)**

Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

**SMALL(**array, k**)** returns the k-th smallest number in this data set.

**ROW(**reference**)**

returns the row number of a reference

**COLUMN(**reference**)
**returns the column number of a reference

*This blog article is one out of five articles on the same subject.*

**Filter values existing in range 1 but not in range 2 using array formula in excel****Filter common values between two ranges using array formula in excel****How to remove common values between two columns****How to find common values from two lists****Highlight common values in two lists using conditional formatting in excel**

Compare values between two columns and filter values existing in only one column

There are text values in column A and column B. The question is how do you compare the values in […]### One Response to “How to remove common values between two columns”

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

Remember to convert less than and larger than signs to html character entities before you post your comment.

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

[...] have a look at this link ad eventually the related pages __________________ Happy with the answer ? Click on the scale [...]