I have several unique formulas I am using for various purposes but none can
solve what I need now. I have two columns (A & B) of items, 3000 rows deep.
There are 15 unique entries in Col A. 150 unique entries in Col B. I want
C1 to be a variable entry whereby I can enter one of the unique Col A items
and return in Col D all the unique entries in Col B for what is entered in C1.

For example:

Col A Col B Col C Col D
ABC 123A ABC 123A
DEF 16LM 437F
ABC 437F
ABC 123A
MNB 789H
ABC 437F

thnx,
casey