Was that question aimed at me? I understand the suggestions you are
giving him, they make perfect sense. I just wanted to clarify to the
original poster that if his data is not sorted, and he has cells that
have random blanks, other with data, he can't just paste that formula
into cell A1 and drag to A14000-he would overwrite his original data.
He would have to find a way to place that formula only in the cells
that are already blank, easiest to me seems to do a sort, right?


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