Conditional list without blank rows
 

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

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