Hey,
my last problem got solved with this Forum so I'll try my luck again. 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;3165+4*(SPALTE(B1)-1))&":"&ADRESSE(384;3165+4*(SPALTE(A1)-1)));VERGLEICH($A12;INDIREKT("[HOURS.xlsm]PLAN!"&ADRESSE(9;3164+4*(SPALTE(B1)-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?
thx for any help
Joel
Bookmarks