Re: Copy a list without the blank cells

Thanks, I gues I wasn't very clear, I do want a list of just the cells
with something in them; I tried using the list functions and that would
work great, but even with custom list filter there are only two
criteria available and they don't seem to take functions or remember
one to the next.

Maybe there is a better way to do this. I am trying to get a list of
items based on the day of the week, but some things are one day a week,
and some things are more than one day a week. Right now, I have on the
master list copied them across seven rows based on which day of the
week. I then was hoping to make a list on a separate *** of the
nonblank cells in a column (e.g., column A on Monday). I have played
around with other options, like listing the items and then the day(s) I
want them on, but that seemed too complex. Is there perhaps an array
formula that would do the trick?

.