comparing two columns of data and return unique data in another co

[ExcelUSER]

I have two set of data. I want to compare the two set of data and display any
data that doesn't show up in one set of data and only show up in one. Is this
possible? Thanks in advance for your help.

 

[ExcelUSER]

I'm actually using EXCEL 2007. Thanks.

 

[Fred Smith]

Without knowing your layout, we can only give you a general idea.

The typical solution is to use Countif. You pick one column, and count the
number of times each entry appears in the other column. Anything equal to
zero is not in the other column.

Regards,
Fred.

 

[ExcelUSER]

An example of the layout is as follows

Data Set 1

Product Amount
A $1
B $2
C $3

Data Set 2

Product Amount
C $3
B $2
D $4

I want the result to be:

Product Amount
A $1
D $4


Thanks.

 

[Fred Smith]

Here's how I would attack the problem:
1. Do the Countif on each dataset
2. Select the zero records (using Data>Filter) of data set 1, and copy
3. Select the zero records of data set 2, and copy.

Regards,
Fred.

 

[ExcelUSER]

Thanks Fred Smith. It worked.

Here's how I would attack the problem:
1. Do the Countif on each dataset
2. Select the zero records (using Data>Filter) of data set 1, and copy
3. Select the zero records of data set 2, and copy.

Regards,
Fred.

 

[Fred Smith]

Glad I could help. Thanks for the feedback.

Fred.