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.

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.

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.