How to list results of certain conditions on other sheets?

[jpbonono]

MS 2003

Sheet 1 has condition:
(Cell BK)
[TABLE="width: 165"]
<tbody>[TR]
[TD="class: xl24, width: 165"]=IF(BJ7=TRUE,B7,0)[/TD]
[/TR]
</tbody>[/TABLE]

QUESTIONS:
1.) Values in B7 are the NAMES OF STUDENTS, if it happens to be false, is it possible to empty cell instead of zero? How?

2.) How am I going to "list" all the results in BK on sheet 2?

Thanks in advance! :D

 

[Drrellik]

=if(bj7=true,b7,"")

 

[jpbonono]

Thanks! how about Question 2? Could you help me as well?

 

[Aladin Akyurek]

MS 2003

Sheet 1 has condition:
(Cell BK)
[TABLE="width: 165"]
<tbody>[TR]
[TD="class: xl24, width: 165"]=IF(BJ7=TRUE,B7,0)
[/TD]
[/TR]
</tbody>[/TABLE]

QUESTIONS:
1.) Values in B7 are the NAMES OF STUDENTS, if it happens to be false, is it possible to empty cell instead of zero? How?

2.) How am I going to "list" all the results in BK on sheet 2?

Thanks in advance! :D

1) One of:

BK7, just enter and copy down:

=IF(BJ7=TRUE,B7,"")

=IF(BJ7,B7,"")

2)

Sheet2

A2, control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX(Sheet1!$BK$7:$BK$100,
  SMALL(IF(Sheet1!$BK$7:$BK$100="","",
  ROW(Sheet1!$BK$7:$BK$100)-ROW(Sheet1!$BK$7)+1),ROWS(A$2:A2))),"")