| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing data in mult rows then summing unique values | Excel Discussion (Misc queries) | |||
| return unique data from a list | Excel Worksheet Functions | |||
| Return unique data from a list | Excel Worksheet Functions | |||
| Comparing two lists and return specified data | Excel Worksheet Functions | |||
| Comparing data in two columns and highlighting the data | Excel Worksheet Functions | |||
Hybrid Mode
