Yes, that is correct. When I type a name in col B, everything goes blank or
empty after the first name in the second row.

I just had a thought you said you tried it in 2003, so I went and checked
and here at work were are still on 2002.

Steve

"Rick Rothstein (MVP - VB)" wrote:

Rick thanks for the formula, unfortunately when I copied the formula down
in
Col C, after the first name in row two, every cell after that is left
blank.

You placed the workers names in A2:A8 (for the list that you posted), right?
You placed the formula in C2 and copied it down to C8, right? With nothing
in Column B, the entire list from Column A should be repeated in Column C.
As you type names in B2 through B8, those names should be removed from the
listing in Column C. This is not happening for you? I just repeated the
procedure I outlined above and it works fine here in Excel 2003.

Rick