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).
Bookmarks