Thank you Biff,its a robust solution.

"Biff" wrote:

Hi!

Try this:

Entered as an array in D2:

=IF(ROWS($1:1)<=COUNTIF($B$2:$B$100,$D$1),INDEX(A$ 2:A$100,SMALL(IF($B$2:$B$100=$D$1,ROW(A$2:A$100)-ROW(A$2)+1),ROWS($1:1))),"")

Copy across to F2 then down.

Biff

"TUNGANA KURMA RAJU" wrote in
message ...
I am having a range a2:a100 student'sNames,b2:b100-standard(std1,std2
etc...),c2:c100-Marks.
Basing on D1 value(say D1=std2) ,I want to extract std2 values of range
a2:c100 to D2:F100( all 3 columns data).Blank range shoud shown as
Blank("").I don't want to it using filter.So,please don't advise me using
filter options on the list.Many thanks if anybody gives me a robust
formula.