the advanced filter will do this for you. check out the help on advanced
filter
"Andrew" wrote:
I have a worksheet with three columns:
Confirmed No // Confirmed Yes // Name
"Confirmed No" contains either a "Y" or a blank as does "Confirmed
Yes"
I want to make a continous list of names that are not confirmed No
(ie. don't have a "Y" in the first column). I want to do this using a
formula. I have the feeling it should be possible using an array
formula with a combination of CountIf and Index but so far the answer
has eluded me.
Has anyone ever had any success with something similar to this.
Thanks a lot,
Andrew
|