You can use the autofilter (Data-Filter-Autofilter), and select "(Non
blanks)" in the quantity column. That will hide all the rows that don't have
data there.

Hope this helps,
Miguel.

"help" wrote:

I need to write a formula that would only print rows that have info in a
quantity column