Forum Discussion
yoshi8rice
Dec 23, 2023Copper Contributor
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....
PeterBartholomew1
Dec 23, 2023Silver Contributor
Again 365, this time based upon a tabular stock list.
= FILTER(Stock[[Description]:[Volume]], NOT(Stock[Qty]))