If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filtering sheet data in another sheet
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 |
#2
|
|||
|
|||
Filtering sheet data in another sheet
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 "khaled shaheen" wrote in message ... 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 |
#3
|
|||
|
|||
Filtering sheet data in another sheet
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 datafilteradvanced 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) "khaled shaheen" wrote in message ... 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 |
#4
|
|||
|
|||
Filtering sheet data in another sheet
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 |
Thread Tools | |
Display Modes | |
|
|