Need formula to draw out minimum values

Thanks for the help dan.
I really wanted the table to autofill, and was finally able to use a formula I got from another forum Thread to draw out unique values from a list.
I typed the following explanation up before I finally realized how to attach the file to this reply, so either read below or view the file to see how I accomplished this.

First I inserted two columns in front of column C.
I inserted the following formula in D10 and dragged down:

Formula:

=E10&G10

I inserted the following formula in C55 and dragged down (don't ask me how it works... I just copied it off of another forum. Make sure to use Shift-Ctrl-Enter!):

Formula:

=IF(ROWS($D$10:D10)<=SUM(IF($D$10:$D$50="","",1/COUNTIF($D$10:$D$50,$D$10:$D$50))),INDEX(D:D,SMALL(IF(IF(ISERROR(ROW($D$10:$D$50)-6=MATCH($D$10:$D$50,$D$10:$D$50,0)),FALSE,ROW($D$10:$D$50)-9=MATCH($D$10:$D$50,$D$10:$D$50,0)),ROW($D$10:$D$50),""),ROWS($D$10:D10))),"")

I used vlookup formulas in column E and G for Table 2:

Formula:

=VLOOKUP($C55,$D$10:$W$49,2,FALSE)

and

Formula:

=VLOOKUP($C55,$D$10:$W$49,4,FALSE)

respectively.
I finally used this formula in cell I55 and dragged down (Shift-Ctrl-Enter!):

Formula:

 =MIN(IF($D$10:$D$49=$C55,$U$10:$U$49))

I think it will work perfectly!