Build a short list based on criteria applied to long list
Posted on 2013-12-31
Experts, ok so I have a partial list of products in Col A (result set).
There are many duplicate products in the result set (which is ok)
In Col B I have a master list of all products (no duplicates here).
In Col C I have a formula that counts how many times each of the products in the complete list appears in the result set.
Now I want to build a unduplicated short list of just those products from the master list that occur one or more times in Col A.
In SQL no problem, I would just select distinct Col A from Worksheet
Or I would Select Col B from Worksheet where Col C > 0
How do I achieve the same results using a formula in Excel (without any sql)?
Thanks in advance.