Try this:
Assuming your source sheet in Sheet 1 and Filter sheet in sheet 2

For Ticker in sheet 2
A2
=IF(ISERR(SMALL(IF(Sheet1!$B$2:$B$1000,ROW(INDIRE CT("1:"&ROWS(Sheet1!$B$2:$B$100)))),ROWS($1:1)))," ",INDEX(Sheet1!$A$2:$A$100,SMALL(IF(Sheet1!$B$2:$B $1000,ROW(INDIRECT("1:"&ROWS(Sheet1!$B$2:$B$100)) )),ROWS($1:1))))

ctrl+shift+enter, not just enter

For Balance in sheet 2
B2 =IF(A2="","",VLOOKUP(A2,Sheet1!$A$2:$B$100,2,0))
Just enter

Select A2:B2 and drag down as far as needed


"khaled shaheen" wrote:

Dears,

here is my problem:

Source sheet Filtered sheet
A B A
B
Ticker Balance Ticker
Balance

HRHO 1000 ...... ......
ACGC 500 ......
......
ESRS 0
ORHD 500
ELEC 0

I want to filter the data in the "Source sheet" to another sheet to only
display those Tickers " A" that have Balance " B" Zero


regards,

Khaled