| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Making list of unique items from two different columns
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tagging unique items in a list | Excel Worksheet Functions | |||
| Function to count unique items in list | Excel Worksheet Functions | |||
| count unique items in ever-growing list? | Excel Discussion (Misc queries) | |||
| Making list of items to truck monthly usage | Excel Discussion (Misc queries) | |||
| Making list with unique columns | Excel Worksheet Functions | |||
Threaded Mode
