| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
making multiple lists from one, with uniqueness
Here's an example of my data:
Foo Fighter Foo Fighter Foo Lishness Foo Lishness Bar Nun Bar Exam Foo D'Eluvit Bar Oque Bar D'Eluvit Bar Nun Foo Lishness Foo Lishness Baz Luhrmann Foo Lishness Baz Ooka Baz Ooka Baz Ebeez Foo Manchu Foo Manchu How can I extract from that a set of lists of Foo's (Fighter, Lishness, D'Eluvit, Manchu), Bar's (Nun, Exam, Oque, D'Eluvit) and Baz's (Luhrmann, Ooka, Ebeez) for data validation? I'd like each item to appear only once in whichever list(s) it applies to, but I don't care about the order. Pick a Foo: ______ Pick a Bar: ______ Pick a Baz: ______ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making Lists of numbers | Excel Discussion (Misc queries) | |||
| help with making a function to filter lists | Excel Worksheet Functions | |||
| Verifying uniqueness of records in data | Excel Discussion (Misc queries) | |||
| Making multiple selections from Excel drop down lists | Excel Worksheet Functions | |||
| Making individualized word lists from a SS | Excel Discussion (Misc queries) | |||
Threaded Mode
