selected student name with multiple condition

[Naresh Maloo]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]s no
[/TD]
[TD]name of student
[/TD]
[TD]class
[/TD]
[TD]cast
[/TD]
[TD]income
[/TD]
[TD]result
[/TD]
[TD]%
[/TD]
[TD]boy/girl
[/TD]
[TD]date of birth
[/TD]
[TD]others
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]nkm
[/TD]
[TD]9
[/TD]
[TD]gen
[/TD]
[TD]40000
[/TD]
[TD]pass
[/TD]
[TD][/TD]
[TD]B
[/TD]
[TD]05.6.90
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]rcp
[/TD]
[TD]9
[/TD]
[TD]gen
[/TD]
[TD]250000
[/TD]
[TD]pass
[/TD]
[TD][/TD]
[TD]B
[/TD]
[TD]07.08.92
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]ulb
[/TD]
[TD]9[/TD]
[TD]gen[/TD]
[TD]30000
[/TD]
[TD]fail
[/TD]
[TD][/TD]
[TD]G
[/TD]
[TD]04.06.89
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]kcm
[/TD]
[TD]10
[/TD]
[TD]sc[/TD]
[TD]30000
[/TD]
[TD]pass
[/TD]
[TD][/TD]
[TD]G
[/TD]
[TD]60.12.90
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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