How to select preceeding cell in a formula?
Hi Dennis,
assuming you will do it on the D column
on cell D1 type 1
on cell D2 use the formula =d1+1
and copy it down
HTH
Regards from Brazil
Marcelo
"Dennis" escreveu:
I need to replicate a formula down a column, where each cell is the value of
the preceeding cell (directly above it) + 1. I have no idea how to do this,
being new to Excel. Any ideas would be really helpful.
Thanks!
|