Printing Criteria

[HWhite]

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.

 

[Joerg Mochikun]

1) In cell AA1 (if your last column is Z) add formula =COUNTBLANK(M11)=4
2) Copy down as needed
3) (Auto)filter all rows where formula returns FALSE
4) Print the filtered list

 

[HWhite]

Thank you for your quick reply!

1) In cell AA1 (if your last column is Z) add formula =COUNTBLANK(M11)=4
2) Copy down as needed
3) (Auto)filter all rows where formula returns FALSE
4) Print the filtered list