S
Scottie
Date 1 2 3 4 5 6 7 8 ...ect..
Employee NameRecord * <-formula in every column with 1 digit result
*
=IF(ISNA(AND(takeoff<=G$86,takeoff>=$G$86,$B87<>"")),"",IF(AND(takeoff<=G$86,takeoff>=$G$86),"",IF(ISNA(VLOOKUP($B87&G$86&$F87,ReqOff,3,FALSE)),IF(ISODD(G$84),IF(VLOOKUP(first_name,staff_data,FSOS+G$83,FALSE)=0,"",VLOOKUP(first_name,staff_data,FSOS+G$83,FALSE)),IF(VLOOKUP(first_name,staff_data,FSES+G$83,FALSE)=0,"",VLOOKUP(first_name,staff_data,FSES+G$83,FALSE))),IF(VLOOKUP(first_name&G$86&$F87,ReqOff,4,FALSE)=0,"",VLOOKUP(first_name&G$86&$F87,ReqOff,4,FALSE)))))
G$86 = Date
G$83 = Week Number
$B87 = Current Shift
That is the formula I am using. Right now it is working relatively okay, it
tends to freak out when I edit it in 2007 while using compatability mode
97-2003.
So the question here is....how can I replace $G$86 with a named range that
will fill across the month. I really need to shorten some of the formula...I
think that will help.
Thanks alot for helping me
Scottie
Employee NameRecord * <-formula in every column with 1 digit result
*
=IF(ISNA(AND(takeoff<=G$86,takeoff>=$G$86,$B87<>"")),"",IF(AND(takeoff<=G$86,takeoff>=$G$86),"",IF(ISNA(VLOOKUP($B87&G$86&$F87,ReqOff,3,FALSE)),IF(ISODD(G$84),IF(VLOOKUP(first_name,staff_data,FSOS+G$83,FALSE)=0,"",VLOOKUP(first_name,staff_data,FSOS+G$83,FALSE)),IF(VLOOKUP(first_name,staff_data,FSES+G$83,FALSE)=0,"",VLOOKUP(first_name,staff_data,FSES+G$83,FALSE))),IF(VLOOKUP(first_name&G$86&$F87,ReqOff,4,FALSE)=0,"",VLOOKUP(first_name&G$86&$F87,ReqOff,4,FALSE)))))
G$86 = Date
G$83 = Week Number
$B87 = Current Shift
That is the formula I am using. Right now it is working relatively okay, it
tends to freak out when I edit it in 2007 while using compatability mode
97-2003.
So the question here is....how can I replace $G$86 with a named range that
will fill across the month. I really need to shorten some of the formula...I
think that will help.
Thanks alot for helping me
Scottie