Stefano,

That should not happen. Would you post the formulas as you adjusted them
to your data?

Stefano Condotta wrote:
Hello Aladin,

I'm afraid your final formula produces a curcular reference error. $C$3
cannot be in the formula. Column B works well. I'm trying to get it to work.
Thanks.
"Aladin Akyurek" wrote in message
...

Let A2:A25 be your first column range with A2 housing a label.

In B1 enter: 0

In B2 enter: Idx [ which is just a label ]

In B3 enter & copy down:

=IF(A3<"",LOOKUP(9.99999999999999E+307,$B$1:B2) +1,"")

In C1 enter:

=LOOKUP(9.99999999999999E+307,B1:B25)

In C2 enter: No Blanks List

In C3 enter & copy down:

=IF(ROW()-($C$3)+1<=$C$1,LOOKUP(ROW()-($C$3)+1,$B$2:$B$25,$A$2:$A$25),"")

From C3 on, you'll have the desired list with no interspersed blank/empty
cells.

Chaturanga wrote:

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