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
|
|||
|
|||
Excel Filter/Query
Hi, I have a table of data laid out in a spreadsheet. I would some way of filtering out the rows that have a zero in one of the columns. A filter works, but I need something different.. because I am exporting this data and it includes the filtered out rows as well. And it needs to be somewhat automated, if possible... maybe it flows into another sheet. Any ideas? I put query in the title because it would return results similar to an access query.. basically create a new table on a new sheet. Thanks in advance! -- proben930 ------------------------------------------------------------------------ proben930's Profile: http://www.excelforum.com/member.php...o&userid=14590 View this thread: http://www.excelforum.com/showthread...hreadid=262175 |
#3
|
|||
|
|||
You can use an Advanced Filter to filter the data to a different sheet.
There are instructions in Excels' help, and he http://www.contextures.com/xladvfilter01.html proben930 wrote: Hi, I have a table of data laid out in a spreadsheet. I would some way of filtering out the rows that have a zero in one of the columns. A filter works, but I need something different.. because I am exporting this data and it includes the filtered out rows as well. And it needs to be somewhat automated, if possible... maybe it flows into another sheet. Any ideas? I put query in the title because it would return results similar to an access query.. basically create a new table on a new sheet. Thanks in advance! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
After installing Windows XP SP2 , how do I open old Excel 2003 fil | Mike D | General Discussion | 2 | September 2nd, 2004 10:21 PM |
Automatically Updating Excel Data In Word Doc Inside Excel File | Business Design Architect | General Discussion | 0 | August 29th, 2004 10:55 PM |
EXCEL TO OUTLLOK | Woodsmith | General Discussion | 0 | July 6th, 2004 12:29 AM |
Excel 2000 crushed | Sue | General Discussion | 3 | June 30th, 2004 12:25 AM |
does EXCEL support multiple display monitors? | Chip Pearson | Charts and Charting | 0 | May 9th, 2004 11:05 PM |