Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do write a formula so that only rows with info prints?
I need to write a formula that would only print rows that have info in a
quantity column |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do write a formula so that only rows with info prints?
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do write a formula so that only rows with info prints?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
If formula result is false, how do I auto-delete that rows? | Excel Worksheet Functions | |||
formula to use when number of rows changes dynamically | Excel Worksheet Functions | |||
Insert rows, keep a formula? | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) |