formula question
 

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........

formula question
 

"DEE" wrote in message
...
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........

Remove the first $, & use
=I$4
--
David Biddulph

formula question
 

I$4

that is make the column relative, without the $

--
HTH

Bob Phillips

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

"DEE" wrote in message
...
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........