Identifying UNIQUE members of a range

[Tarver]

I have a large table of products, sold at multiple retailers, as below. I need to produce a list of unique products at a specific retailer (a subset of the total list.) I'm trying to use the new UNIQUE function and I can get a list of unique items in my table, but I can't pare if down to the subset I need. For example, here's a snippet of what my data looks like:

I have thousands of lines of data like this. My goal would be to have a user select a retailer (say Walgreen's) and get the unique entries in column B only, for just those that appear in Walgreen's. I can get a table of unique entries for all products for all retailers, but I can't seem to get it to filter down to just the products at the selected retailer.

Any advice would be most appreciated!

 

[Fluff]

If you put the retailer name in D1 & use
=UNIQUE(FILTER(B2:B100,A2:A100=D1))

 

[Tarver]

If you put the retailer name in D1 & use
=UNIQUE(FILTER(B2:B100,A2:A100=D1))

Fluff, you're my hero. That's two questions of mine in a row that you've made short work of. Thank you very much. Works like a charm!

 

[Fluff]

Glad to help & thanks for the feedback.