View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jonah
 
Posts: n/a
Default 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