I think I understand what you are looking for, in fact on the same day
I answered to your post I answered a similar post, which was looking
for exactly this. Assuming again your data is in 'Data'!A2:B20. Column
A:A contains the colors, column B:B contains the classification.

In your output sheet I am assuming you are entering the first row
(A1:C1) exactly as it appears in your post, i.e.:
Win/Tie: Lose: Not Enough Data:
In other words, let the two categories in A1 be together, separated
somehow. The formula is based on the assumption that both categories
will appear in the cell.

In A2 (*array formula again*):

=INDEX(Data!$A$2:$A$20,MATCH(1,-
-(ISNUMBER(FIND(Data!$B$2:$B$20,A$1))),0))

Copy this formula through A2:C2

In A3 (*array formula*):

=IF(ISNUMBER(MATCH(1,(ISNUMBER(FIND(Data!$B$2:$B$2 0,A$1)))*(COUNTIF(A$2:A2,Data!$A$2:$A$20)=0),0)),I NDEX(Data!$A$2:$A$20,MATCH(1,(ISNUMBER(FIND(Data!$ B$2:$B$20,A$1)))*(COUNTIF(A$2:A2,Data!$A$2:$A$20)= 0),0)),"")

Copy across and down. That should do it, if I have understood correctly
what you want to do.

As for where I learned Excel, I am a programmer, who found it easy to
learn the basics of Excel. Then, through the teaching of Business
Computing for several years I augmented my techniques repertoire.
Lately I started following this group more closely and I have learned
even more advanced techniques. The formulas I used here I learned in
this group: In fact I was struggling for a similar formula myself and
had only managed to do it using two columns, until I saw a post by Bob
Phillips, a frequent contributor to these groups, which was extracting
a collection of unique values from a set of data. The formulas you see
here are an adaptation of this formula.

HTH
Kostis Vezerides