Please Help Combine to Two Lists

  • Thread starter Thread starter lostinformulas
  • Start date Start date
L

lostinformulas

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
 
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.
 
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 :)
 
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
 
Back
Top