combine two sets of data columns based on matching values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Theo - 30 Jan 2007 23:59 GMT

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

Reply to this Message

Martin Fishlock - 31 Jan 2007 03:30 GMT

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.

Signature

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

> 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
[quoted text clipped - 8 lines]
> Thanks for your time,
> Theo

Reply to this Message

Theo - 01 Feb 2007 14:28 GMT

On Jan 30, 9:30 pm, Martin Fishlock
<martin_fishl...@yahoo.co.uk.cutthis> wrote:

> Hi Theo:
>
[quoted text clipped - 35 lines]
>
> - Show quoted text -

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

Reply to this Message