Trying to create a formula that will display items in a clean list

I am trying to create a more sophisticated formula that will do the following:

Formula in Column C that will check Column B for the word "TRUE". If a cell in Column B contains "TRUE", then display the content in the corresponding cell in Column A.

For example: =IF(B2=TRUE,"A2","")

Screen Shot 2013-04-25 at 3.59.55 PM.png

The only problem with the function above is it only checks one specific cell, rather than the entire column. Also, If I drag this formula down across several rows, It leaves a Blank where the result is False.

I would like to find a formula that will search the entire Column B... and for every cell that contains the word TRUE, List the items from Column A, but without spaces. So Column C will contain only the TRUE items in a clean, "space free" list.

For example:

Screen Shot 2013-04-25 at 4.01.24 PM.png

I would appreciate any help or suggestions you can give me!

Thanks,
JNLONG

Kevin,

Thanks for the quick reply! I pasted the above formula in cell C1 and then clicked Command + Enter (for mac) and copied the formula down through 8 rows. The result shows only the name "Jared" in each of the cells in Column C. See attached.

Screen Shot 2013-04-25 at 4.41.34 PM.png

I'm unsure what the key combination is for... COMMAND + ENTER. Perhaps I'm doing it wrong?

Any additional help would be greatly appreciated

Thanks,
JNLONG

Thank you !
I was looking for the same thing as jnlong. It works perfectly.

Worked like a charm. Thank you Kevin UK!

Thank you Tony, this formula works great!