Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
3 range criteria for Loop
I'm trying to populate a work schedule with different tasks, If a
employee A2 is working in a time range E1:EI1 (Time of Day) with start time B2 and an end Time C2 that is within the Time of Day Range And a task is required E34 E25 And the employee can do the task AK2 = "X" Then the cell in the loop range should = E24 (The task name) Then loop this for each employee in range A1:A100 The actual formula that works looks like this : =IF(AND(E$1=$B2,E$1<=$C2,$E$24=$AK$1,$AK$2="X",$E $34$E$25),$E$24,"" It works but I don't know how to apply through all of the cells in loop Thanks -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reset the range of FOR loop | Excel Discussion (Misc queries) | |||
Loop through last cell/row of used range | Excel Discussion (Misc queries) | |||
Adding criteria to loop | Excel Worksheet Functions | |||
Loop QUESTION to end of data range... | Excel Worksheet Functions | |||
Loop a long formula through range | Excel Programming |