Filtering sheet data in another sheet

[Guest]

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

 

[CLR]

Try Data > Filter > Autofilter........select zero from the dropdown arrow in
column B.......then copy and paste the visible rows over to the Filtered
sheet.............note, this can all be done by macro if it's something yo
do frequently........

Vaya con Dios,
Chuck, CABGx3

 

[Peo Sjoblom]

Insert a few rows on top of the table,
in A1 put Ticker in B1 put Balance
leave A2 blank (you really don't need the values in A1 but if you want to
filter on values in A as well it could be handy)

in B2 put

0

now go to the sheet where you want the filtered table, select for instance
A1 in sheet3
do data>filter>advanced filter, click in the list range box and then click
the source sheet tab and select the table, could look like
Sheet1!$A$4:$B$100

click in the criteria range box and select Sheet1!$B$1:$B$2

now select copy to another location, go sheet3 and click in the cell where
you want the filtered table to start
click OK

That should do it


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[Guest]

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$100>0,ROW(INDIRECT("1:"&ROWS(Sheet1!$B$2:$B$100)))),ROWS($1:1))),"",INDEX(Sheet1!$A$2:$A$100,SMALL(IF(Sheet1!$B$2:$B$100>0,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