Generate list based on another list without FALSE values

[Britcramble]

Hello,

I have a dynamic list in column A which contains various names, and multiple instances of the value FALSE.
I would like another list in column B, which has the same values, but without the FALSE values.

For example:
Blue
Yellow
Green
FALSE
Turqoise
FALSE
FALSE
Black
FALSE
White

Would become:
Blue
Yellow
Green
Turqoise
Black
White

I can't quite work out a formula to do it. Thanks in advance!
Cheers.

 

[Aladin Akyurek]

In B2 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($A$2:$A$100,SMALL(IF($A$2:$A$100=FALSE,"",ROW($A$2:$A$100)-ROW($A$2)+1),ROWS($B$2:B2))),"")

 

[Britcramble]

Sorry I should have pointed out that I want to use a formula, and not a filter, as the list will be referenced on other sheets.

 

[Britcramble]

Oops just got ninjad.

Thanks Aladin that works perfectly!!!

 

[Aladin Akyurek]

Oops just got ninjad.

Thanks Aladin that works perfectly!!!

You are welcome.