[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 333
  • Last Modified:

consolidate two excel lists

Hello Experts

I have two lists with common data.  
I need to create one list with no duplicates.  

list one is an excel sheet with data from an attached .csv file.
list two is an attached access table.  
Is there a way to "Lookup" from more than one list?

AJP     Excel Lists
0
AMixMaster
Asked:
AMixMaster
1 Solution
 
RamanhpCommented:
please refer the attachement
Consolidated-List.xlsx
0
 
Patrick MatthewsCommented:
AMixMaster,

1) There was no attached file

2) What if a single product has multiple codes?  For example, if list 1 has:

Prod1,Code1
Prod2,Code2
Prod3,Code3
Prod4,Code4

and list 2 has:

Prod1,Code5
Prod5,Code6
Prod6,Code7
Prod2,Code2

then what would the expected output be?  Note that Prod1 appears on both lists but with different codes, and that Prod2 appears on both lists but using the same code.

Patrick
0
 
ukerandiCommented:
hi check my example in the attached Excel file, Click on command1 button. if you want to more than 30 records you need to go code page and edit amount what you want
RemoveDuplicates.xls
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
AMixMasterAuthor Commented:
Product codes are unique
0
 
AMixMasterAuthor Commented:
We would need to consolidate the lists first brfore running a pivot table.
Still need the code to eliminate the duplicates
0
 
ukerandiCommented:
have you run my code
0
 
AMixMasterAuthor Commented:
ukerandi,

Your post was one second before my last comment!

Actually, I need a lookup with reference to different columns to be dispalyed.
However, Your code does what the example asks for.

Thanks

AJP

ps
Check this Guy out  :)  www.cpearson.com
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now