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


--
lostinformulas
------------------------------------------------------------------------
lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
View this thread: http://www.excelforum.com/showthread...hreadid=566199

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.
--
paul

remove nospam for email addy!



"lostinformulas" wrote:


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


--
lostinformulas
------------------------------------------------------------------------
lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
View this thread: http://www.excelforum.com/showthread...hreadid=566199

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 :)


--
teelim


------------------------------------------------------------------------
teelim's Profile: http://www.excelforum.com/member.php...o&userid=36856
View this thread: http://www.excelforum.com/showthread...hreadid=566199

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


--
lostinformulas
------------------------------------------------------------------------
lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
View this thread: http://www.excelforum.com/showthread...hreadid=566199