selected student name with multiple condition

[Naresh Maloo]

s no	name of student	class	cast	income	result	%	boy/girl	date of birth	others
1	nkm	9	gen	40000	pass		B	05.6.90
2	rcp	9	gen	250000	pass		B	07.08.92
3	ulb	9	gen	30000	fail		G	04.06.89
4	kcm	10	sc	30000	pass		G	60.12.90

<tbody>
</tbody>

I WANT IN NEXT SHEET OF EXCEL SAME ATTACHED TABLE HEADING WITH CONDITION SUCH AS NAME OF THOSE STUDENT WHICH BELONGS TO CLASS 9 , CAST GEN , RESULT PASS , BOY AND INCOME MUST >50000.
what will be formula for this in excel 2007. thanking in advance.

 

[azumi]

Assumed your table in ranges A1:J5 (Include Header):

=IFERROR(INDEX($B$2:$B$5,SMALL(IF(($C$2:$C$5=9)*($E$2:$E$5>50000)*($F$2:$F$5="Pass")*($H$2:$H$5="B"),ROW($B$2:$B$5)-ROW($B$2)+1),ROWS($A$1:A1))),"")

Array FOrmula (means when ENTER you need to press CTRL-SHIFT-ENTER button together)
and copied down