| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 58098 | 2005-05-21 14:12:00 | Excel formula | bpt2 (6653) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 357265 | 2005-05-21 14:12:00 | 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? | bpt2 (6653) | ||
| 357266 | 2005-05-21 15:01:00 | A filter example (www.contextures.com) | gibler (49) | ||
| 357267 | 2005-05-21 21:42:00 | 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. |
Parry (5696) | ||
| 357268 | 2005-05-22 00:23:00 | All so easy, thanks. | bpt2 (6653) | ||
| 1 | |||||