View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Joerg Mochikun Joerg Mochikun is offline
external usenet poster
 
Posts: 104
Default 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.