Korean Job Discussion Forums

[Confused Canadian]

I'm trying to set up my grading spreadsheet for the coming semester, and I'm having a little trouble copying formulas.

What I want is:

A1 = Z1
A2 = Z3
A3 = Z5
A4 = Z7

and so on.

When I try and just copy the formulas, I get one of two results:

A1 = Z1
A2 = Z2
A3 = Z3
A4 = Z4

or if I try to copy two cells at a time:

A1 = Z1
A2 = Z3
A3 = Z3
A4 = Z5

I know I could just enter things manually, but I'm hoping there's an easier way to do this.

Can any Excel guru's help me out?

Cheers!

[morituri]

Not an excel guru, but this seems to work:

Note A1 is mapped to Z1, A2 to Z3, A3 to Z5, and in general A[n] to Z[2n-1].

1] Assuming 100 non-blank rows in column A which contain relevant data, type next to them the numbers 1,2,3, �, 100 in cells B1, B2, B3,

2] In cell C1 write =(B1+1)/2, drag down mouse to repeat formula to C100, so that C2=(B2+1)/2, �, C100=(B100+1)/2.

3] In cell D1 write =OFFSET($A$1,-1+MATCH($C1,$B$1:$B$100,1),0,1,1), drag mouse down to repeat formula to D100.

4] In cell E1 write =if(mod(row(E1,2)=0,"",D1), drag mouse down to E100

5] In cell Z1 write =E1, drag mouse to Z100

[Confused Canadian]

Thanks for the reply. Will give it a shot in the next day or two and let you know if it does the trick. Looks like it should!

Cheers!

[morituri]

My pleasure. Hope it works.