When i drag down the formula from Cell A1, it goes like this, cell
A1:c1/b1, cell A2:c2/b2, cell A3: c3/b3, cell A4:c4/b4 and so on..

I would like the formula to be like this, cell A1:c1/b1, cell A2:c2/b1,
cell A3: c3/b1, cell A4: c4/b1 ..

How do i keep it constant at b1? Any form of assistance will be
appreciated. Thanks in advance!

Regards,
Matt


--
boneyzz
------------------------------------------------------------------------
boneyzz's Profile: http://www.excelforum.com/member.php...o&userid=30927
View this thread: http://www.excelforum.com/showthread...hreadid=506024