Please Help Combine to Two Lists

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lostinformulas - 28 Jul 2006 23:32 GMT

If Anyone could help it would be GREAT!

I have two lists with 3 columns and approximately 1500 row each
One List is for US and the other is for Canada

Column A = Product
Column B = Vendor
Column C = Code

I need one list that combines both of these list

Hopefully with two extra columns that indicates (this can be on a
separate sheet)
Column E = US = X
Column F = Canada = X

If a Product with the same Vendor and Code appear in both list I only
need it to show up once with a X in each of the US and Canada Columns.
The X will be used for an auto filter later.

Any help would be appreciate
Thanks
Lostinformulas

Signature

lostinformulas

Reply to this Message

paul - 29 Jul 2006 06:58 GMT

you could just copy one list onto the bottom of the other and then sort the
whole lot
You obviously put the X onto the respective lists before you combine
them.When you sort thecombined list the duplicates will be next to each
other.

Signature

paul
paul.shepherd@nospamparadise.net.nz
remove nospam for email addy!

> If Anyone could help it would be GREAT!
>
[quoted text clipped - 19 lines]
> Thanks
> Lostinformulas

Reply to this Message

teelim - 29 Jul 2006 15:48 GMT

try this:

paste one sheet below the other and sort.

then in a separate column (say column G), key in this:
=IF(AND(A2=A3,B2=B3,C2=C3),"x","")

use AUTOFILTER for column G and only display BLANKS. Only the unique
combinations will be displayed.

hope this is what you want :)

Signature

teelim

Reply to this Message

lostinformulas - 31 Jul 2006 17:06 GMT

Thank you both it was most helpful. The formula worked great. Is there a
way to add to the formula to delete the duplicate line???

=IF(AND(A2=A3,B2=B3,C2=C3),"x","")

Thanks Again.
Lostinformulas

Signature

lostinformulas

Reply to this Message