Select a block of cells in another column, best to be same size as the data,
and enter this formula in the formula bar

=IF(ISERROR(SMALL(IF(NOT($B$1:$B$20),ROW($A1:$A20) ,""),ROW($A1:$A20))),"",IN
DEX($A$1:$A$20,SMALL(IF(NOT($B1:$B20),ROW($A1:$A20 ),""),ROW($A1:$A20))))

as an array formula, so commit with Ctrl-Shift-Enter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Chaturanga" wrote in message
oups.com...
Hello,


I'm looking for a worksheet formula that will produce a list of no
blank values in a third column. First column contains the text values
(30 rows) and they already listed with no blanks. The second column has
boolean TRUE or FALSE values corresponding with the values in the first
column. I'm looking for a formula that will list all first column
values with corresponding second column values that are FALSE in the
third column with no blanks.

Thanks