| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
| conditional formating for a blank cell | Excel Discussion (Misc queries) | |||
| Can I have a list, when opening, go to first blank row in the lis. | Excel Discussion (Misc queries) | |||
| Removing unused or blank rows and columns | Excel Discussion (Misc queries) | |||
| macro to not print blank value rows in invoice | Excel Worksheet Functions | |||
Linear Mode
