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!
Bookmarks