C
casey
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
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