OK, I got it to work sorta. I have a ton of data i've already entere
by hand and i dont' want to lose it so i cut the existing cost data an
threw it on another tab. I put in your formula on a larger range tha
my existing data and then pasted my data back in. On my test sheet th
formula works fine if the formula is in every cell except the firs
occurence of the model but if i have manually entered data stop
autofilling reoccurrences, do i need a phantom hidden E4 cell o
something to maintain continuity?

Thanks for the help Gents. :)

Cheers,
Dave Corve

--
cynder7
-----------------------------------------------------------------------
cynder77's Profile: http://www.excelforum.com/member.php...fo&userid=1537
View this thread: http://www.excelforum.com/showthread.php?threadid=26991