Thread
:
Offset Problem
View Single Post
#
5
Posted to microsoft.public.excel.misc
Stefi
external usenet poster
Posts: 2,646
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
Reply With Quote
Stefi
View Public Profile
Find all posts by Stefi