Thread: Offset Problem
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Offset Problem

Enter this formula in B1 and pull it down to B10:
=INDEX(A:A,2*ROW()-1)+INDEX(A:A,2*ROW())

Regards,
Stefi

€žDawn€ť ezt Ă*rta:

There are Collum A1-A20,
Want:B1=A1+A2;B2=A3+A4;€¦B10=A19+A20;
How to realize it ?
Thanks
Dawn