How do write a formula so that only rows with info prints?

H

help

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

Miguel Zapico

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

Pete_UK

In a spare column to the right of the main data (i.e. out of the print
range) add a simple formula to copy the quantity column, eg =G2 if
column G is the quantity column, and copy this down as necessary. Where
you have blanks in column G, these will show as 0 in this helper
column.

Highlight the column and click Data | Filter | Autofilter to turn on
autofilter for this column only. Then, to select only those columns
containing data, you can apply a filter as follows:

Custom | Does Not Equal | 0 (zero)

and only the non-blank rows will be visible.

Hope this helps.

Pete
 
Top