I have a table for event planning where A is the items and B is the quantities I then want it to turn into a list where it just has the items if B is more than 0. I have tried using =QUERY(Job!A3:B16, SELECT A WHERE B <> '0') but I get #VALUE! back and the error pop up says "In Array Literal, an Array Literal was missing values for one or more rows. is there a better formula to use or a better way to use this. Thanks in advance

CodePudding user response：

Try

=QUERY(Job!A3:B16, "SELECT A WHERE B <> 0 ")

you can also use FILTER

=FILTER(Job!A3:A16,Job!B3:B16<>0)