For the first formula...

=IF(ROWS(B$10:B10)<=COUNTIF($A$1:$A$7,"*"&$A$10),I NDEX(B$1:B$7,SMALL(IF(R
IGHT($A$1:$A$7,2)=$A$10,ROW($A$1:$A$7)-ROW($A$1)+1),ROWS(B$10:B10))),"")

For the second formula...

=IF(ROWS(B$10:B10)<=COUNTIF($A$1:$A$7,"*"&$A$10&"* "),INDEX(B$1:B$7,SMALL(
IF(ISNUMBER(SEARCH($A$10,$A$1:$A$7)),ROW($A$1:$A$7 )-ROW($A$1)+1),ROWS(B$1
0:B10))),"")

Hope this helps!

In article ,
xlarch wrote:

Thanks for your help.
What if "sh" is a variable that i want to keep changing, i.e a10 is a
variable, so that when i put different values in a10, i get different sets of
data?
Can either of the formulae (the two you sent me and the original one) be
made to work in that way?
thanks again Domenic