Get Unique List with multiple conditions

Dear forummembers,

I'm trying to retrieve certain values from a dataset (horizontally orientated like this).UnList Source.gif

For each column in range O:V I need a list with data from unique customernumber (Custno).

But only:

- IF Artno is not empty
- IF Custno is "123abc" a extra row needs to be added to the unique list which states Custno "456abc" (and Group and Artno with the data from custno "123abc")

I've managed to get the list, only not the unique-part

Here is my code and attached my testfile.

I'm sure this is easypeasy for you but I just can't figure it out. So....help me please...

Please Login or Register  to view this content.

@JLGWhiz, thanks I've adjusted the code.

@xladept, thanks I adjusted the workbook and added a before and after sheet. Hope this helps to clarify my question.

Yes, of course.

Using the Instr function ( [start], parent_string, substring, [compare] ) duplicates are prevented.

Thank you XLADEPT, this bypass does exactly what I was looking for.

Have a sunny day!

Best regards,

mamaexcel