I get the same result, the formula changes down the column BUT th
result shows identical for each cell in the column. A way I have foun
that does get it to give the correct answer is to select the cell an
then select and it then gives me the correct answer (this only work
with my original formula and not with the suggested formula)
Any ideas?
Patric

--
crowdx4
-----------------------------------------------------------------------
crowdx42's Profile: http://www.excelforum.com/member.php...fo&userid=3774
View this thread: http://www.excelforum.com/showthread.php?threadid=57351