Column A is a list. Column B has “x” in some cells.
I need to create a named range, using a formula, that is populated with items from Column A when there is a corresponding “x” in column B.

This is actualy a larger project that has a list of Activities in a column A, and several columns (B-F) of catagories named "C2-C8". "x" is used in to indicate which catagory an activity falls into. I need to create names lists (arrays?) populated with the items included in each catagory. If I could get the first column working Im sure I could sort out the duplicates.

I'm using Excel 2007. Also I cannot use a macro in this workbook.
I’ll be grateful for any help
Robert