How do I find Non-Intersection of 2 Columns?

  • Thread starter Thread starter Bucyruss
  • Start date Start date
B

Bucyruss

Can anyone tell me how to compare two columns in excel and produce
result column of only the cells that are unique to one (or both
columns (i.e., non-intersecting value subset). For example, if I hav
one column which containes values in 5 cells as follows: A, B, C, D,
and another column that contained values in 3 cells as follows: A, B
E

I would like to be able to produce a new column which would have value
in only 2 cells: C, D, since these are the values not common to bot
original columns.

I seem to recall that old versions of Excel had a database functio
which made this rather easy, but I've been unable to figure this ou
since that function was replaced by the pivot table function
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup, hlookup and return value of intersecting cell 3
Using Intersecting Names for lookup 2
Excel Concatenate with line breaks but ignore blank cells 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
LOOKUP problem with non-sorted vector 3
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Find previous number and find next number in column 4

Back
Top