generating list of names ending by a variable string

Since my previous question did not receive many replies, I am rephrasing my question using Carim's words...

Ok, I would like to know if it is possible to have some kind of formula which generates automatically a list of names ending by a variable string (i.e by).

I have a list of names and I use the following formula to list the names ending in "by": =SUMPRODUKT(--(RIGHT(A1:A600;2)="by"))

However, this formula only calculates the number of words ending in by, but it does not list those words in a separate column. How could i adapt my formula in order to get such a list?

CHEERS ALL !:-)

would this help:

lets say your list of names is in column A. In column B, you enter:
=IF(right(A1,2)="by",A1,"")


Mangesh

Let 's assume your columns F,G,H are empty ...
in cell F1 just type 0
in cell F2 type formula
=IF((RIGHT(A2,2)=$G$1),LOOKUP(9.99999999999999E+30 7,$F$1:F1)+1,"")
copy this formula all the way down ... your 800 lines
in cell G1 type by
in cell H3 type formula
=IF(N(IF(ROW()-ROW(G$3)+1<=LOOKUP(9.99999999999999E+307,$F$2:$F$800 ),MATCH(ROW()-ROW(G$3)+1,$F$2:$F$800),"")),INDEX('Extract End'!A$2:A$800,IF(ROW()-ROW(G$3)+1<=LOOKUP(9.99999999999999E+307,$F$2:$F$800 ),MATCH(ROW()-ROW(G$3)+1,$F$2:$F$800),"")),"")
copy this formula all the way down ... your 800 lines

Let's hope it works out the way you want ...
Carim