List unique values from two lists

[William Daniels]

I am trying to find a way to compare two rows of data and list the values in one row that do not appear in the other row. Below shows the data I am working on. I want to compare the values in Row 18, Columns D thru S with values in Row 25, Columns D thru S. I want the resulting numbers to appear in a single cell separated by commas. For the data shown the results in the cell would be 10,15,16.


There are some blanks in the rows indicated as b.



Columns D E F G H I J K L M N O P Q R S
Row 18 1 2 3 4 b b b[FONT=&quot][/FONT] b 9 10 11 12 13 14 15 16
There are rows between the two.
Row 25 1 9 12 b 2 7 11 b 3 8 13 b 4 9 14 b

I am using Excel 2007 and have tried to use the INDEX and MATCH functions, but I can’t get the solution. I would appreciate any help you can provide.

William Daniels

 

[brettdj]

William,

There is a List option as well as a Highlight option, I think you ran the latter which is the addin default

Regards

Dave

 

[William Daniels]

Thank you for your reply. I will give this a try.

William Daniels

I tried this macro today and it worked fine. Thanks again.

William Daniels