creating columns with data from offset rows

[Scott Kelley]

I have 5 "channels" of data that I'm bringing into a spreadsheet. Each of
these channels is represented by numbers in two consecutive rows of column C
that I then need to combine to one number. Example, C5 & C6 / C7 & C8 / C9
& C10 / C11 & C12 / C13 & C14 then starting over with C15 & C16.

I want to combine these sets of cells into new columns D thru H.

Column D for instance would consist of:
D5 C5 * 100 + C6
D6 C15 * 100 + C16
D7 C25 * 100 + C26

Column E will consist of
E5 C7 * 100 +C8
E6 C17 *100 +C18
E7 C27 *100 +C28

and so on

What I need to know is how to set this up so that I can create the D thru H
columns in a way that I don't have to manually create each cell. Auto Fill
is the only thing that I'm familiar with for duplication of cells, but it
doesn't work here.

Thanks for any help
Scott Kelley

 

[Guest]

Check out the OFFSET function, in conjunction with ROW.
Your forumula in D5, for example, would be something like
=100*OFFSET($C$5,10*(ROW()-5),0,+OFFSET($C$6,10*(ROW()-5),0).
--Bruce

 

[Scott Kelley]

Hey . . . that was pretty easy! Works great, thanks.
Scott