Hi!

Here's the "quick and dirty" version:

=INDEX(A$2:A$1200,SMALL(IF(LEFT(A$2:A$1200,3)="raj ",ROW($1:$1199)),ROW(A1)))

Here's the "robust" version:

=IF(ROWS($1:1)<=COUNTIF(A$2:A$1200,"Raj*"),INDEX(A $2:A$1200,SMALL(IF(LEFT(A$2:A$1200,3)="raj",ROW(A$ 2:A$1200)-ROW(A$2)+1),ROWS($1:1))),"")

Copy down. Both array entered.

Biff

"TUNGANA KURMA RAJU" wrote in
message ...
I am looking for array formula for
range a2:a1200
Rajiv
Raju
Anita
Rajan
Prem
Ram
extract all the text values from the range that begins with "raj"
string(not
case sensitive)
Output results be: Rajiv
Raju
Rajan