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

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.

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

I'm actually using EXCEL 2007. Thanks.

"ExcelUSER" wrote:

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.

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

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" wrote in message
...
I'm actually using EXCEL 2007. Thanks.

"ExcelUSER" wrote:

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.

comparing two columns of data and return unique data in anothe
 

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" wrote:

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" wrote in message
...
I'm actually using EXCEL 2007. Thanks.

"ExcelUSER" wrote:

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.

comparing two columns of data and return unique data in anothe
 

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

Regards,
Fred.

"ExcelUSER" wrote in message
...
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" wrote:

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" wrote in message
...
I'm actually using EXCEL 2007. Thanks.

"ExcelUSER" wrote:

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.

comparing two columns of data and return unique data in anothe
 

Thanks Fred Smith. It worked.

"Fred Smith" wrote:

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

Regards,
Fred.

"ExcelUSER" wrote in message
...
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" wrote:

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" wrote in message
...
I'm actually using EXCEL 2007. Thanks.

"ExcelUSER" wrote:

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.

comparing two columns of data and return unique data in anothe
 

Glad I could help. Thanks for the feedback.

Fred.

"ExcelUSER" wrote in message
...
Thanks Fred Smith. It worked.

"Fred Smith" wrote:

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

Regards,
Fred.

"ExcelUSER" wrote in message
...
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" wrote:

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" wrote in message
...
I'm actually using EXCEL 2007. Thanks.

"ExcelUSER" wrote:

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.