Compare List of Stores & List of Products per store

[AB1234]

I have a list of stores in question & a list of products per store. 

I need to find out if Product A, B & C are in all of the stores in question, if not, which product(s) are missing from what store and if there are any additional stores in which the products are showing up in?

List of stores in question

Store 10

Store 20

Store 30

Store 40

Store 500

List of products	List of stores per product
Product A	Store 10
Product A	Store 20
Product A	Store 30
Product A	Store 40
Product A	Store 500
Product B	Store 10
Product B	Store 20
Product B	Store 30
Product C	Store 10
Product C	Store 20
Product C	Store 30
Product C	Store 40
Product C	Store 500
Product C	Store 600
Product C	Store 700

Thank you all in advance.

[bpatel · Accepted solution]

hi @AB1234 ,

Here is what i came up with. Let me now if this is what you are looking for!

[benakesh · Accepted solution]

Hi @AB1234 ,

Check this for missing and additional stores. 

[AB1234]

Thank you so much for your help! Your workflow works great!!!!

[AB1234]

What a great workflow! Thank you so much for your help!!!