Find not listed items

[plans]

Hello,
I have this attached spreadsheet which contains two columns.
The rows of those columns vary.
I am trying to get a macro (not looping) to display a message indicating the items from the column at the right (in yellow), not found in the column on the left.
In this case: COX11; COX10.
Could you please advise?
Thanks!

[Mumps1]

What do you mean by "not looping"?

[alansidman]

With Power Query which is part of your version of Excel.



Excel 2016 (Windows) 32 bit

	A
1	Table3.Column1
2	W18
3	W15
4	W14
5	CC2 Low TUZ
6	CC2 High TUZ
7	COX11
8	W17 TUZ
9	W11 TUZ
10	COX10
11	DDR TT 4 FR
12	DDR TT 7 FR

Sheet: Merge1

[plans]

Mumphs1,

"not looping" - I meant without using a nested loop.
I am able to do that but it can take too long.
I am thinking about a way to compare the two ranges and display the not matching line items.
FYI
Thanks for looking into this!

[plans]

alansidman,

Thanks for looking into this.
I need it though, through a VBA.
Thanks!

[Mumps1]

This macro uses looping through an array and therefore should be pretty fast:

Please Login or Register  to view this content.

[Haluk]

If you don't wanna use a loop, then using a Left Join in ADO/SQL may be an alternative to PQ

Note that, you've to add the reference "Microsoft ActiveX Data Objects 6.1 Library" to your project via Tools >> References menu in VBE

Sample file is also attached....

Please Login or Register  to view this content.

[plans]

Mumps1 and Haluk,

Thanks a lot.
Both solutions work!

[Mumps1]

Glad to help out.