Difficulty finding which products total of products offer are not sold to each client.

Hello,

In my example below, I'd like to extract the data of which products are not being sold to a client. The products sold column has several different products in one cell. How can I find out which products aren't being sold to a client?



Client Products Sold Which products are not sold?
ABC 0006;0100,0030;0002;,0222;0043;0056; ?
0078;0090

XYZ 0203;0006;0043;0154;0055;0455;0056 ?

1AA 006;0100;0043;0078;0070 ?

Schedule of Products:
6
100
30
2
222
43
56
78
90
203
154
55
455
70

*edited to post file

* Edited post again *** changes below:

So one of the problems I'm facing is that I have duplicate entries for the same client, I need to consolidate them to one entry per client and then have a cell (or cells) that shows what products are not "in force" with that client. Thank you for your attention, anyone who helps me with this will surely be compensated for their input.

please upload a sample file.

Hi, SteffSmith90,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Ciao,
Holger

Your file appears to be corrupt, could you upload it again - and make sure that your sample data closely matches your actual data