I forgot to answer the second part of your question....
Enter this in the "C" column cell;

=IF(A5&B5="",D4,0)

I think that this is what you are asking for.

--
"...I''m just a simple man, trying to make my way in the universe..."


"flyingby" wrote:


1-If any row in column A is empty enter "Unassigned" but only do so if
Column B in that same row is not empty

2-If any row has empty fields in both column A and B switch column c of
that same row to column D of the prior row.

I need to do this for 14k rows is there any formula or macro that might
be able to do this?


--
flyingby
------------------------------------------------------------------------
flyingby's Profile: http://www.excelforum.com/member.php...o&userid=27844
View this thread: http://www.excelforum.com/showthread...hreadid=473523