Printing lists based on values

[newtoecel]

Is this the right forum for this question?
I would like to print a list of members based on a value in another column B C D based on a value of 1 print name on report.
report B would contain
Allen
Carol
Dave

report C would contain
Bob
Dave
Ed

report D would contain
Allen
Carol
Ed



A B C D

NAME MON TUES WED

Allen 1 0 1

Bob 0 1 0

Carol 1 0 1

Dave 1 1 0

Ed 0 1 1

[p24leclerc]

activate the autofilter on your data, then select to show only the 1 on column B and your list will be as you want. You can now print it. Change the filter of column B, C or D to suit your needs.