combine two sets of data columns based on matching values

[Theo]

I have two sets of data that are coming from a common set of database
records. One has a number of columns that correspond to a number of
attributes and the other set has a number of columns that correspond
to a different set of attributes. . Each set has a column that lists
the record id. One of the sets is a subset of the other based on the
record id.
I would like to get a new (third) set that will list all the unique
columns from each of the two sets of data for the rows that have a
matching id.

Thanks for your time,
Theo

 

[Guest]

Hi Theo:

There may be better ways to do it but I think that what you want in find are
the items where they are not equal.

So for a one off exercise:

In a new column on the end of set_1 put

=if(isna(match(a1,set_2!a:a,o)),"Need","")

In a new column on the end of set_2 put

=if(isna(match(a1,set_1!a:a,o)),"Need","")

Then sort the data on the Need column in
both the worksheet and then copy the data
where there is a need in the rwo to the new sheet.
I think that you are there then.

 

[Theo]

Hi Theo:

There may be better ways to do it but I think that what you want in find are
the items where they are not equal.

So for a one off exercise:

In a new column on the end of set_1 put

=if(isna(match(a1,set_2!a:a,o)),"Need","")

In a new column on the end of set_2 put

=if(isna(match(a1,set_1!a:a,o)),"Need","")

Then sort the data on the Need column in
both the worksheet and then copy the data
where there is a need in the rwo to the new sheet.
I think that you are there then.

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.






- Show quoted text -

Martin,
this is exactly what I was looking for, thank you very much!