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....
=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.