formula question

D

DEE

How can I automatically drag this formula into other columns?
Example: $I$4 1st column
$J$4 2nd column
$K$4 3rd Column
etc, etc........
 
D

David Biddulph

DEE said:
How can I automatically drag this formula into other columns?
Example: $I$4 1st column
$J$4 2nd column
$K$4 3rd Column
etc, etc........
Click to expand...

Remove the first $, & use
=I$4
 
B

Bob Phillips

I$4

that is make the column relative, without the $

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top