vba code to find duplicates in two lists

[fruitloop44]

hi!

i have two lists in the attached file, one is my inventory (col A:C) and one is what i want to match it against (col E:F). The results i want from the macro are in columns H:L.

IM not sure if its possible to write a code for this but... i would like a way to see the duplicate value on the two lists under the ticker columns, meaning if the inventory list has AAPL and the match list has AAPL then AAPL will end u in the result column BUT it will end up there the exact amount of times that it appears on each list so AAPL is on the first list twice and on the second list 2 times so it comes up twice under matches in results and 3 times under needed in the results. the only criteria that needs to be matches is the tickers but i am having difficulty finding ways to align the quantity and counterparty since the amounts can differ on each list. please let me know if you can help with a code for this or a better way. thank you!!!

[AlphaFrog]

It looks like you are just duplicating the two lists, but deleting the unique items in each and lining up in the same rows the matched tickers. Is that correct or am I missing something?

[nilem]

Hi fruitloop44,
try it

Please Login or Register  to view this content.

[fruitloop44]

Exactly that

It looks like you are just duplicating the two lists, but deleting the unique items in each and lining up in the same rows the matched tickers. Is that correct or am I missing something?

[fruitloop44]

This works!! Thank you!! Can you explain the code?
I did F8 through it but there's only action in the last few lines so it was hard to follow.

Hi fruitloop44,
try it

Please Login or Register  to view this content.