+ Reply to Thread
Results 1 to 2 of 2

Need to pull non-zero values from one sheet to another in a list

  1. #1
    Registered User
    Join Date
    08-31-2010
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2007
    Posts
    17

    Need to pull non-zero values from one sheet to another in a list

    Hello,

    I'm having an issue with a formula and I'm hoping to get some assistance. I apologize if this has been covered before, but I did a search and didn't have any luck.

    So I have a sheet with accounts in the first column, budgets across the top row, and a variety of values in the range:

    Budget1, Budget2, Budget3, Budget4, Budget5, etc...
    Account1 0 0 0 0 0
    Account2 250 0 -750 2100 7
    Account3 -21 100 0 0 75
    Account4 -75 80 25 5 -5
    Account5 500 0 50 -6 0

    I'm trying to pull in *ONLY* the non-zero values to a second sheet in just in a column in a list form. Also, ideally I'd be able to pull in the account and budget in two adjacent cells, but the main thing is just eliminating the zeros since they are not needed for what I'm trying to do.

    Any assistance that you can provide would be greatly appreciated!

    Thanks!
    Chris

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Need to pull non-zero values from one sheet to another in a list

    Do you need to remove the zeros for visual purposes only? If so, go to worksheet options and set the options so that zero values aren't to be displayed.

    You could also make a filtered list to show non-zero values.

    If you need to sum the values, SUMIF could be set to ignore zero values
    Click on star (*) below if this helps

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1