Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Criteria
Hello all...
Let's say I have a spreadsheet with columns A-Z. In columns M, N, O, and P there are yes/no entries that may or may not apply for each record. "Y" entries are filled in, "N" entries are blank. I only want to print those records that have an entry in one or more of those columns and not print the records where those columns are empty. How would I go about doing that? Thanks very much for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Criteria
1) In cell AA1 (if your last column is Z) add formula =COUNTBLANK(M1:P1)=4
2) Copy down as needed 3) (Auto)filter all rows where formula returns FALSE 4) Print the filtered list "HWhite" wrote in message ... Hello all... Let's say I have a spreadsheet with columns A-Z. In columns M, N, O, and P there are yes/no entries that may or may not apply for each record. "Y" entries are filled in, "N" entries are blank. I only want to print those records that have an entry in one or more of those columns and not print the records where those columns are empty. How would I go about doing that? Thanks very much for your help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Criteria
Thank you for your quick reply!
"Joerg Mochikun" wrote: 1) In cell AA1 (if your last column is Z) add formula =COUNTBLANK(M1:P1)=4 2) Copy down as needed 3) (Auto)filter all rows where formula returns FALSE 4) Print the filtered list "HWhite" wrote in message ... Hello all... Let's say I have a spreadsheet with columns A-Z. In columns M, N, O, and P there are yes/no entries that may or may not apply for each record. "Y" entries are filled in, "N" entries are blank. I only want to print those records that have an entry in one or more of those columns and not print the records where those columns are empty. How would I go about doing that? Thanks very much for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Printing using criteria | Excel Worksheet Functions | |||
Printing certain criteria | Excel Discussion (Misc queries) | |||
Can I select a worksheet based upon a cell criteria?(for printing) | Excel Worksheet Functions | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |