That is another good suggestion, but you would either need to sort the
data first, or add a temporary column and make the formula something
like "=if(C10,"unassigned",B1). This formula assumes you have
inserted your temp column in column A to put your formula. when you
run the formula on all the cells you can copy/paste-special (values
only) back into B, then delete A.

I assume column A already has some blanks and some data mixed in it,
thats why you need to either sort first or use the temp column approach
for the formulas.... unless I am missing something.


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=473523