I have a list where users have selected. If the all of the data cells are
not complete then I want to exclude the cells from the analysis that will
follow. To do that, I change the name of the item to
"ITEM_NOT_AVAILABLE_FOR_ANALYSIS". On separate tabs of my workbook I want
users to use a drop down list of the items they have entered.

I start with a list that looks like this:
test 123
a
b
ITEM_NOT_READY_FOR_ANALYSIS
ITEM_NOT_READY_FOR_ANALYSIS
ITEM_NOT_READY_FOR_ANALYSIS
test 456


I want to use formulas or code to get the list to look like this:
test 123
a
b
test 456.

How can I do that? Any help would be greatly appreciated. I've been going
after this for weeks.
--
PLJ