The formula works if implemented properly. If it's not working properly
you'd have to give me the EXACT DETAILS of your problem including the EXACT
formula you're using.

Wouldn't macro be lot faster anyway?

Maybe, maybe not. I don't write code. (yet!)

Biff

"sa02000" wrote in
message ...

Thanks for reply Biff.
This seem to take too long for excel to calculate all the cells when I
copy the formula down and then all it does is gives me odd numbers...
1, 3, 5, etc. in the cells........ Any suggestions. Wouldn't macro be
lot faster anyway?

Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile:
http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=569539