Results 1 to 4 of 4

Thread: Excel formula

  1. #1
    Senior Member
    Join Date
    Dec 2004
    Posts
    376

    Default Excel formula

    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?

  2. #2
    Elite
    Join Date
    Feb 2005
    Location
    Dunedin
    Posts
    1,597

    Default Re: Excel formula

    A filter example

  3. #3
    Senior Member
    Join Date
    Dec 2004
    Location
    Wellington, NZ
    Posts
    353

    Default Re: Excel formula

    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.

  4. #4
    Senior Member
    Join Date
    Dec 2004
    Posts
    376

    Default Re: Excel formula

    All so easy, thanks.

Similar Threads

  1. Excel formula
    By bpt2 in forum PressF1
    Replies: 10
    Last Post: 04-02-2008, 07:31 AM
  2. Excel Formula
    By Happy Harry in forum PressF1
    Replies: 2
    Last Post: 18-01-2007, 01:26 PM
  3. Excel formula
    By appanna in forum PressF1
    Replies: 2
    Last Post: 06-05-2003, 03:54 PM
  4. Excel Formula help
    By flying_green_leprachaun in forum PressF1
    Replies: 3
    Last Post: 10-09-2002, 09:01 PM
  5. Excel Formula
    By Donald M in forum PressF1
    Replies: 4
    Last Post: 30-07-2002, 03:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •