Biff,

I do have a few questions for you on your formula:

=IF(COLUMNS($A:A)<=COUNTIF(INDEX($B$2:$F$10,MATCH( $A13,$A$2:$A
$10,0),),"Yes"),
INDEX($B$1:$F$1,SMALL(IF(($A$2:$A$10=$A13)*($B$2:$ F
$10="Yes"),COLUMN($B2:$F10)-MIN(COLUMN($B2:$F10))
+1),COLUMNS($A:A))),"")

In the Columns($A:A) portions, how come the second A is a relative
reference and not an absolute (I.e., when I drag it across, it becomes
$A:B, etc). (Same holds for the Column formulas... Why are the
columns absolute but the rows relative?).

Also in the latter part of the formula, I redid it like this and it
works:

COLUMN(Data!$B$2:$AG$439)-MIN(COLUMN($B$2:$AG$439))+1)

You'll notice that i put a link to the Data spreadsheet in the first
part of the formula but not in the "-Min(Column)" part of the
formula. It works the same if I include the link to Data in the
second part of the formula
COLUMN(Data!$B$2:$AG$439)-MIN(COLUMN(Data!$B$2:$AG$439))+1).

Any idea why it works both ways?

(Questions really for my edification).