Results 1 to 6 of 6

Dynamically select non-zero rows labels and corresponding values

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2010
    Location
    delaware, us
    MS-Off Ver
    Excel 2007
    Posts
    2

    Dynamically select non-zero rows labels and corresponding values

    I have a data table with items in each row, a column for each year, and then the cell values contain dollar amounts.
    I need to populate tables on the 2nd tab with the Items when the value is greater than zero for that year, and the values for that corresponding item. When the value for that year is zero, I don't want that Item to be reported on the yearly output table.
    Pivot tables with value filters don't work because I need the output tables to always be a standard size (# of rows).
    I can use vlookups for the dollar value in each year's table once I have the items, but need a formula to identify the Items in a given year that have a non-zero value (without duplicates).
    Attached Files Attached Files

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