View Full Version : Excel formula

22-05-2005, 01:12 AM
I have a table of data in which column B may have a "0" value. I want to create a new table which only includes those rows where column B does not have a "0" value. How do I do this?

22-05-2005, 02:01 AM
A filter example (http://www.contextures.com/xladvfilter01.html)

22-05-2005, 08:42 AM
For such a simple filter you can just used the standard Autofilter.

1. First off ensure you have a header row (ie a name for each column of data)
2. Select any cell in the data range then choose Data|Filter|AutoFilter from the menu. You should see drop downs on the header row.
3. Select the drop down arrow for column B then choose the Custom option. In the dialog box that appears, select Does Not Equal in the left drop down and 0 in the right.
4. Your data is now filtered so just copy this to a new sheet.

To remove the autofilter simply select Data|Filter|AutoFilter again.

22-05-2005, 11:23 AM
All so easy, thanks.