View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phil Phil is offline
external usenet poster
 
Posts: 7
Default 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: ______