fill handly, auto fill problem

[Schnezler]

Hey,

I'm working on a sheet for my university. Everything is working fine now, but i cant use the fill handle/ fill data option of Excel the way i want to.

=INDEX(INDIREKT("[HOURS.xlsm]PLAN!"&ADRESSE(9;3165+4*(SPALTE(A1)-1))&":"&ADRESSE(384;3165+4*(SPALTE(A1)-1)));VERGLEICH($A12;INDIREKT("[HOURS.xlsm]PLAN!"&ADRESSE(9;3164+4*(SPALTE(A1)-1))&":"&ADRESSE(384;3164+4*(SPALTE(A1)-1)));0))

This would be my first column. In the second Column I need some other ours but on the same day. I just realised ours are sometimes split. So the formula for the second row would look something like this:

=INDEX(INDIREKT("[HOURS.xlsm]PLAN!"&ADRESSE(9;3166+4*(SPALTE(A1)-1))&":"&ADRESSE(384;3166+4*(SPALTE(A1)-1)));VERGLEICH($A12;INDIREKT("[HOURS.xlsm]PLAN!"&ADRESSE(9;3164+4*(SPALTE(A1)-1))&":"&ADRESSE(384;3164+4*(SPALTE(A1)-1)));0))

So the A1 needs to change to B1 and it does if i only pull one row. If i start pulling two rows it changes to C1 immediatly. Why? and how do i get excel to do what i want :D.


Any suggestions? Do you need more info? Just tell me I'll answer asap.

thx for any help
Schnezler

 

[BobUmlas]

Even with a simple formula, like =A1, if you use the fill handle to go 2 columns to the right, you'll get =C1. If you want =B1 to show up, you can fill one column (getting B1), then cut/paste to the next column and the B won't change to C.
Or, I'm totally misunderstanding what you want to do. By the way, I don't see any difference in the 2 formulas you supplied.

 

[Schnezler]

By the way, I don't see any difference in the 2 formulas you supplied.

The only difference is where it looks for the hours. The 3165 changes to 3166. The first one looks for student hours and the other one for students hours who held a little lecture that day. I need to pull this data out of a huge sheet and my task is to sum stuff up and provide the data to the prof.

So i have one day and two colums on one day. One with the hours attended and one with the hours were you held a little lecture. (hope you understand it im german trying to learn english )

That way i have two colums with two different values that i want to pull to the right to get it done fast for a whole semester.

Thx for your answer