Hi there,

I'm trying to figure out a better way to do this - since the formula is
already too long for the cell (and I don't want to split it between two
cells, I want to find a better, more automatic way.

So this is my formula (same thing repeated with more cells)

=IF(BK$6="DE",($B$6 & ", "),"")&(IF(BK$7="DE",$B$7 & ",
",""))&(IF(BK$8="DE",$B$8 & ", ",""))&(IF(BK$9="DE",$B$9 & ",
",""))&(IF(BK$10="DE",$B$10 & ", ",""))....etc.

I've looked at Lookup, but it doesn't seem to allow for finding numerous
occurances and listing them out. I could be mistaken though.

Please help!

Thank you,
Alison