Create Named List (range) based on check list

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

Pike, thanks for the reply!
I dont understand what you meant in the last sentance, Should I be using this as the formula in the Named range or using it to build a helper column?
Robert

Originally Posted by pike

hi Hammer_757
As you probably know this names range will be dynamic and off one column
=OFFSET(Sheet1!$A$1,0,1,COUNTA(Sheet1!$A:$A),1)
Do have list from x's you would need helper columns to seperate the data

Thanks Martin, I have downloaded the file and will work with it tomorrow.
Robert

Originally Posted by martindwilson

heres a named range called test