if the intermediate cells are unused you can use a
=if(row()=2*(int(row()/2)),your formula,"") this can be copied down
through all rows

Or

use a macro to copy it down into every other row.

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=535370