Increment column by column from data row by row
Superb! And is it possible from another workbook? I would never have found
that in the Help without knowing what I was looking for.
Jonah
Peo Sjoblom wrote:
Do you want to increment down row wise while you copy across?
If you want to increment like B2, B3 and so on while copying across you can
use
=OFFSET($B$2,COLUMN(A:A)-1,)
--
Regards,
Peo Sjoblom
(No private emails please)
"Jonah" wrote in message
...
No luck there. Any other thoughts
Jonah
JE McGimpsey wrote:
Try =$A2+B2 instead
|