Forum Discussion
Trying to see a way to add a row from another sheet that has a value of 0 in a column
I'm using Excel for my inventory and there are some cells in Column A that has a value of 0, and I want to see if I can copy that row into another sheet to show what I have that is out of stock only.
Thank you for your help.
The picture shown above on column A shows a 0 value, so I want to copy the row into another sheet to show what I have that is out of stock.
Again 365, this time based upon a tabular stock list.
= FILTER(Stock[[Description]:[Volume]], NOT(Stock[Qty]))=FILTER(A1:C13,A1:A13=0)
Easiest way would be the FILTER function which is available in recent versions of Excel.
The result can be returned on another sheet as well.
