Hi,
I'm trying to set up a sheet for the office that will give us a quick print out of inventory.
I have a csv I can export which I would like to draw from using some array formulas in order to create a list of all items with a positive quantity. My first column is the list of items, second is the corresponding quantities. I've been online for about 3 hours now trying to put a solution together, but I feel like I've gotten nowhere.
I need my resulting list to be all the items with a non-zero quantity and the quantity number along side it.
I have my simple attempt which leaves blank spaces on zero values:
And my over-complicated attempt (which I barely understand) that duplicates entries where the previous list left them blank:
I appreciate your input in advance.
Bookmarks